Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community !
I have 5 files that have the same schema and I want to check then:
If field1 = "a" && field2 = "b" => copy the files to dest1
If field1! = "a" && field2! = "b" => copy the files to dest2
But a problem appears during the execution
Hi,
When you are reading the columns, you need to do Null check also. The empty strings from an input file will be converted as Null. So you need to check the Null relational check also as shown below.
Relational.ISNULL(row1.data)?null:row1.data
The above statement will pass null if the input is null else it will pass actual data. You need to do similar null checks before doing matching or add additional null matching logic in if condition.
Also in 4.png, you are trying to match two different strings in both sides. If you want the output of tFlowtoIterate, please give Control+Space and it will show the available variables. You need to select them and then do the matching.
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 🙂