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

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

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