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.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables