Filtering Dataset using expression binding

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')
2 Likes