Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a column named subject.
I want to filter out records only with subjects as Maths or English.
i want to implement this in tmap.
i can use the filter expression
row1.subject.equas("Maths") || row1.subject.equals("English")
But is there some other way because i have multiple values and not just 2 . Some thing similar to 'IN' operator
You can put these values into a file, then read it with a tFileInputDelimited connected to a tMap as a lookup.
In the tMap, connect row1.subject to the lookup field to define the join between the main and the lookup rows (very basic and standard pattern). If subject are static, you can replace tFileInputDelimited by tFixedFlowInput.