topic Re: How can I combine columns? in Talend Studio

How can I combine columns?

Anonymous — Sat, 16 Nov 2024 14:22:43 GMT

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!

Re: How can I combine columns?

Anonymous — Tue, 13 May 2008 11:03:54 GMT

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

shong

Re: How can I combine columns?

Anonymous — Tue, 13 May 2008 13:17:43 GMT

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

Re: How can I combine columns?

_AnonymousUser — Tue, 13 May 2008 13:54:09 GMT

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

Re: How can I combine columns?

Anonymous — Tue, 13 May 2008 15:41:58 GMT

I hope this was helpful for you.

Yes it does help me, Thanks a lot Theo!