Trying to see if this is possible on tMap. I have data coming in from row1. Sometimes, row1.field2 has data and sometimes it's null. Is there a way when doing lookup between row 1 and row 2, I can specify "if row1.field2 is null then ignore lookup but still process row1 data into row4, else lookup row2.col5 and push row1 and row2 data into row4"?
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
Gives the error "lookup_value cannot be resolved to a variable" when I used "Relational.ISNULL( row1.field2)? null: lookup_value".
Tried "row1.field2.isEmpty()?"":row1.field2" but that doesn't work either -- in this case, because row1.field2 is null, the whole record is ignored and not pushed into row4.
"lookup_value" was a dummy variable I had told to give you an example. You need to provide the right varible instead from the lookup table, say row1.field2.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
Could you please share 5 sample input and lookup records along with current job flow and mapping screenshots? Please also specify expected output data. I will try it from my end.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
