help to transpose data

[rohit1804]

HI Team,

I have data like ,

input:

1

2

3

desired output

1,2,3

please help me to achieve this....

[manodwhb]

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

[rohit1804]

Hi Manohar,

this is my job, still input file has data like 

1

2

3 

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.

[manodwhb]

@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