topic Re: Merge two text files, row by row, to create one new column in Talend Studio

Merge two text files, row by row, to create one new column

Anonymous — Tue, 23 May 2017 17:49:57 GMT

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:

John

Peter

Sandra

The second file contains a list of surnames like so:

Williams

Alkema

Smith

The 2 files will always have the same number of records.

I need to join these 2 files together, line by line, like so:

John Williams

Peter Alkema

Sandra Smith

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.

Thank you

Anonymous — Tue, 23 May 2017 18:22:56 GMT

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.

TRF — Tue, 23 May 2017 18:37:17 GMT

Here a solution:

tMap to add a sequence (you 2 with the same model):

tMap to join the records:

Anonymous — Tue, 23 May 2017 18:41:29 GMT

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.

TRF — Fri, 26 May 2017 21:29:24 GMT

@necrolingus, did you test the proposed solution?

Anonymous — Sat, 27 May 2017 18:07:14 GMT

Hi there

I got around to testing the solution and it is working great.

I subsequently moved away from files and used a hashmap, and things are looking good!

TRF — Sat, 27 May 2017 18:37:05 GMT

Great!