topic help to transpose data in Talend Studio

help to transpose data

rohit1804 — Tue, 02 Jun 2020 12:21:39 GMT

HI Team,

I have data like ,

input:

desired output

1,2,3

please help me to achieve this....

Re: help to transpose data

manodwhb — Tue, 02 Jun 2020 12:26:21 GMT

@rohit1804 , you can do with tDenormalize ,please check the below way.

Re: help to transpose data

rohit1804 — Tue, 02 Jun 2020 12:49:33 GMT

Hi Manohar,

this is my job, still input file has data like

but while running job it giving error as " Type mismatch: cannot convert from String to int " . Even my input has only one column which is int and in all component i set column as int only.

Re: help to transpose data

manodwhb — Tue, 02 Jun 2020 13:06:00 GMT

@rohit1804 , can you show the screenshot of tDenormatize, I have taken as string data type in source and tdenormalize components.

some where in your job you have are may be reading as int and which you were trying into string in tdenormalize because of which you are getting Type mismatch: cannot convert from String to int