I need to filter a MySQL table to 1. exclude a field name in one column and 2. pass rows that contain permutations of keywords that occur within a string in multiple other columns.
Using tMySQLInput --> tMap --> tMySQLInput with !row1.CAT1.equals("IT") in an input expression I have succeeded with goal 1.
[list=*]
I have not been able to find out how to pass a list of wildcards using tFilterRow or any other component. The key words are %temp%, %recruit%, and %sourc%. (I use % because it is familiar to my MySQL queries.)
[list=*]
What I am hoping to find is something like: row1.ColumnName.contains(%temp%|%recruit%|%source%) that I can put in a variable regex expression filter in tMap or an advanced expression in tFilterRow.
I am new to Java coding so any best practices/advice/code would be greatly appreciated. Thank you for the help, I have learned a lot from this community.
Hi, Have you checked this component TalendHelpCenter:tMysqlTableList which is used to list the names of a given set of Mysql tables using a select statement based on a Where clause? Best regards Sabrina
