Thursday, January 28, 2016

How to implement 'LIKE' operator in Talend

In here ‘LIKE’ operator means similar to SQL like command.
In tMap filter expression you can use contains function from Java.
For example, if you need to filter only the row contains “uma”. Similar way you can use Java pattern matching code also.
row2.ScheduleDay.contains (“uma”) && row2.SheduleTime.contains (“uma”)

You also can use context variable for the expression
row2.ScheduleDay.contains(context.Day)) &&  row2.SheduleTime.contains(context.Hour) ))

Cheers! Uma

1 comment: