Good day guys
I am having difficulty with a specific use case in Talend. I have simplified my problem a bit below:
I have two text files, one contains a list of names like so:
The second file contains a list of surnames like so:
The 2 files will always have the same number of records.
I need to join these 2 files together, line by line, like so:
In Java this is rather straight forward. One can read the names into and array, and then the surnames into an array, and loop through them like so:
for (int i = 0; i < name_array.length(); i++)
System.out.println (name_array[i] + " " + surname_array[i]);
But how can I do this in Talend? I need to write the combined string out to a file again.
Solved! Go to Solution.
If you simply want to join them sequentially, you could add a sequence to each input (using tMap) and then use a third tMap to join them on sequence.
Thank you to you both. You guys are too awesome! And thank you for building the job for me with screenshots, I really appreciate it.
I am back at work on Thursday and will try it out. I will let you guys know how it goes.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Accelerate your data lake projects with an agile approach