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.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend