ETL: filtering with tMap (expression filter)

Issue Description

We have a requirement to separate records with odd IDs (1, 3, 5 ..) from even IDs (2, 4, 6 ..) and store them in 2 separate Excel files.

Resolution

You could utilize tMap filter expression using "row1.id % 2 == 0" for even IDs and "row1.id % 2 != 0" for odd IDs respectively.

Attached ETL job demonstrates a simple use-case using random text generator and 2 resulting Excel files.