How to append columns to other columns in Talend?

Question

I have two hash inputs, each has completely different columns. Say hashInput_1 has columns called

One | Two | Three | Four | Five

and hashInput_2 has columns called:

Six | Seven | Eight

Each hash input has the same number of rows. I just need to combine them into one excel document or flow so that the columns and all of the data gets correctly joined. I know talend can append rows, but I need to append columns so that the new schema is columns One | Two | Three | Four | Five | Six | Seven | Eight with all of the data in the appropriate columns.

Yes same amount of rows. Row 1 in the first file will have information for the same person as the first row in the second file, and so on. So they just need to be appended vertically. — mastercool, Oct 23 '20 at 10:55
You can try to add column ID increment it like 1 to X on the two hashinput and do a join on the ID column in a tmap — Théo Capdet, Oct 23 '20 at 11:11
You Need to add à Column to each input with a sequence to increment id and join in tmap on this two column — Théo Capdet, Oct 23 '20 at 12:40
Okay I have added the sequence counter to both. Not entirely sure what you mean by join in tmap? This is different than tJoin? — mastercool, Oct 23 '20 at 12:47

score 1 · Accepted Answer · answered Oct 23 '20 at 12:56

1

You need to add one more column ID in each of the schema of hashinput.

In the lookup increment this column with a sequence. (See in tjavarow code).

In the tmap increment another sequence and do a join betwen the two ID column.

So first line of one hashinput (ID 1) will join first line other hashinput (ID 1).

answered Oct 23 '20 at 12:56

Théo Capdet

1,042
3
18
34

That makes sense. Thanks!! – mastercool Oct 23 '20 at 12:56

How to append columns to other columns in Talend?

1 Answers1