Trying to combine 2 columns in 1, i.e. trying to put column B values in separate rows (not trying to concatenate. I can concatenate using tMap = row1.xxx+row2.xxx). Below is an example of what I'm looking to do:
Column A | Column B
Seattle | Portland
Los Angeles | Sacramento
Solved! Go to Solution.
Thank you for getting back! Tried it, but still concatenating the result for me. tLogRow output is:
Screenshots attached. (The order does not matter).
Just tried tFileOutputDelimited -- same result as tLogRow. Still concatenating with \n.
Created new tFileInputDelimited with Row Separator "\n" and Field Separator ",".
tMap still same as the screenshot.
tFileOutputDelimited same values: row 1 = Seattle\nPortland, row 2 = Los Angeles\nSacramento
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables