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
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.