Hello Do you have some document regarding what kind of option we can use in the Filter Conditin(and) in tMap exemple I'm trying to filter data from table using this syntaxt row2.projectID.equals(33) the projectID is a INT type I have an error on my tMap "Orror on row2.projectID.equals(33) => Cannot invoke equals(int) on a primitive type int
And what is the correct syntaxt for not equals to 33 or to null? THX DN
Denis, If your are in a JavaProject, the equal condition for a INTEGER is not the same that for a STRING. Test in your case the following syntax : row2.projectID == 33 Regards.
Denis,
An "Int" cannot be NULL but an "Integer" can be NULL.
Verify your Schema, and change with "Integer" (check Nullable -> true), and you can test your expression : row2.projectID == null
Regards
Hi all, I am new to Talend. I am trying to figure out how to filter out an excel column based on the column name without writing java code. For example if I want to skip all the columns whose names start with 'derive_' can I do it with tMap or something else within Talend? Thanks
Maybe post this as a separate thread instead of hijacking this one. you'll get a better response.
My suggestion:
Add a tMap. On the right hand side add a field called "worksheet" with the following variable as the expression: (replace with the correct global name)
((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET"))
Then use tFilterRow to filter rows that include or exclude the worksheet names you want.
Let me know if this helps.
