topic Re: [resolved] Mapping two or more columns in same source to one target column in Talend Studio

[resolved] Mapping two or more columns in same source to one target column

Anonymous — Sat, 16 Nov 2024 13:42:20 GMT

Hi there,
Currently I am using an Excel spreadsheet with the columns Phone Number, Fax Number, and Email; I would like to map all these columns into a single column Address in my target spreadsheet, and have each phone number, fax number, and email to be instances of this Address column. How can I do this?
Please note that I would like EACH phone number, fax number, and email to be separate instances of Address -- for example, if I had 10 rows of phone numbers, fax numbers, and emails, my target column of Address should end up with 30 entries.
Thanks,
Karen

Re: [resolved] Mapping two or more columns in same source to one target column

Anonymous — Tue, 03 Nov 2009 06:40:56 GMT

Hello
Your job looks like:
tFileInputExcel--tJavaRow--tNormalize--tFileOutputExcel
On tJavaRow, there is one column:conn output table, concatenate all the input column with one character, eg:
output_row.conn=input_row.phone+"@"+input_row.fax+"@"+input_row.email;
On tNormalize, normalize conn column with item separator "@"
Best regards

shong

Re: [resolved] Mapping two or more columns in same source to one target column

Anonymous — Tue, 03 Nov 2009 17:01:47 GMT

Thank you, shong.
I tried it and it works!