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

[Anonymous]

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

[TRF]

There is no attachment

[joearun4u]

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.