Yes, in my Integraton Toolkit module. The where() expression function, in particular.
If you just want specific row indices, like the first two rows, use idx()
in the condition, like so:
where({path.to.source.dataset}, idx() < 2)
If you actually want to check the content, like matching the 3-letter prefix on ProductCode
, you'd do something like this:
where({path.to.source.dataset}, left(it()['ProductCode'], 3) = 'BAN')