topic Re: Combine columns together, not concatenate in Talend Studio

Combine columns together, not concatenate

zalibra — Fri, 17 Aug 2018 21:08:07 GMT

Hi all,

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:

Original file:

Column A | Column B

Seattle | Portland

Los Angeles | Sacramento

Desired output:

Column A

Seattle

Los Angeles

Portland

Sacramento

Re: Combine columns together, not concatenate

TRF — Fri, 17 Aug 2018 21:32:01 GMT

If the order for the result doesn't matter and the output is a file, using tMap you can do:
row1.colA + "\\n" + row1.colB
The result will be:
Seattle
Portland
Los Angeles
Sacramento

Re: Combine columns together, not concatenate

zalibra — Fri, 17 Aug 2018 21:42:53 GMT

Hi TRF,

Thank you for getting back! Tried it, but still concatenating the result for me. tLogRow output is:

Seattle\nPortland

Los Angeles\nSacramento.

Screenshots attached. (The order does not matter).

tMap mapping.jpg

Re: Combine columns together, not concatenate

TRF — Fri, 17 Aug 2018 21:44:57 GMT

What if you replace tLogRow by tFileOutputDelimited?

Re: Combine columns together, not concatenate

zalibra — Fri, 17 Aug 2018 21:45:14 GMT

Ah, "and the output is a file"! Let me try that.

Re: Combine columns together, not concatenate

zalibra — Fri, 17 Aug 2018 21:59:51 GMT

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

Re: Combine columns together, not concatenate

zalibra — Fri, 17 Aug 2018 22:12:33 GMT

Got it! Removed one "\" from tMap.

Re: Combine columns together, not concatenate

TRF — Sat, 18 Aug 2018 08:16:14 GMT

Great! Sorry for the mistake.