How to identify a record from an Input File is passing through a tUnite Component from another record in another Input File

[Anonymous]

Hello Talend Community,

I have two files connected to a tUnite Component I need to identify in a Output Column in a tMap If the record is coming from this File then Output this Value. If it's coming from the other File then Output this Value. It's going to be an IF THEN ELSE Statement. If someone can help me with the syntax for this in a tMap Expression.

tFileInputDelimited_1 = "Value1"

tFileInputDelimited_2 = "Value2"

Job is Setup in Cavas like this   Input File1  ---->  tUnite ----> tMap ---> Output File

                                                    Input File2----> 

Any help with this syntax would be greatly appreciated

[manodwhb · Accepted solution]

@sm . I suggest yo to create the below way. first create a constant filed and the do the tunite. check the attached code.

test_data.zip

[Anonymous]

Hello @manodwhb 

I'm running into an issue with my job. My job is setup similar to yours listed in your ScreenShot. The only difference is adding a tMap after the tUnite Component to do some transofrmations on the data, and using a tfileOutputdelimited. Have you ran into any issues with the tUnite component not passing all the records through to the output?

I have a unique ID column in my input file and none of data is getting outputted to the Output Column. It's a 1 to 1 mapping in my tMap Component. The Column Names/Date Type is the same in both columns.

I'm getting a Schema are Different warning next to the tUnite_1 component but I can assure you the schemas are the same just different column names

Have you ran into any issues like this?