topic tDeliminated same data in different columns, how do I join them? in Talend Studio

tDeliminated same data in different columns, how do I join them?

Anonymous — Wed, 10 Apr 2019 08:20:37 GMT

Hello,

my problem is that when I refresh preview in tDeliminated there is like 60 columns and I need like 8. As you can see in attachment there are 3 numbers that should be in the same column but they divided into more and I dont know how to join them. Other data also splitted, is there some compontent for it or do I do it with tMap?

Thank you

Re: tDeliminated same data in different columns, how do I join them?

TRF — Wed, 10 Apr 2019 09:09:57 GMT

There is no attachment

Re: tDeliminated same data in different columns, how do I join them?

joearun4u — Wed, 10 Apr 2019 12:54:57 GMT

Hi @ThePejnMan ,

You can do split the column value to multiple columns with the help of tMap and also you can do reduce the no of columns in output dataflow in tMap.

Give more details to assist further.

Thanks,

Joe

Dont forget to give kudos or solution accepted when you find this reply is useful.