How can I combine columns?

One Star

How can I combine columns?

Hi,
I have several shemas with two columns, one columns is the id, the other one is the information concerned to the id. Now, I want to combine these shemas as one shema with one column of id and other columns with information concerned. How can I do?
Thank you!
Community Manager

Re: How can I combine columns?

Hello
Does the tUnite compoent fit your need?
Please show detailed information about your data source? file or database?
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: How can I combine columns?

Hi,
For exemples, I want to get the result like this:
file1 file 2 file3
ID;INFOR1 ID;INFOR2 ID;INFOR3
1;dd 1;11 1;dfff
2;df 2;22 2;uyyy
3;cc 3;33 3;hnnn
4;wa 4;44 4;hppp
5;fe 5;55 5;fooo

Now I want to get a unique file:
ID;INFOR1;INFOR2;INFOR3
1;dd;11;dfff
2;df;22;uyyy
3;cc;33;hnnn
4;wa;44;hppp
5;fe;55;fooo
How can I do?
thanks
Not applicable

Re: How can I combine columns?

Hello,
I would do it this way:
- Use three tFileInputDelimited (one for each file), define the schemas as "ID" and "INFO"
- Use a tMap and connect it with all file inputs. Set up the schema and expressions like in the screenshot below
I hope this was helpful for you.
Regards,
Theo
Edit: The expressions looking like ro... in the screenshot are row1.ID, row1.INFO, row2.INFO and row3.INFO
One Star

Re: How can I combine columns?

I hope this was helpful for you.

Yes it does help me, Thanks a lot Theo!