topic Re: Convert Rows to Dynamic Columns with respective data in Talend Studio

Convert Rows to Dynamic Columns with respective data

kuwaryogi27 — Mon, 11 Nov 2019 11:50:18 GMT

Hello All,

I have referred to the existing solutions but didn't match my scenario can you please have a look for the attachments that describes the clear idea of the requirement.

Thanks in advance.

Re: Convert Rows to Dynamic Columns with respective data

manodwhb — Mon, 11 Nov 2019 11:56:43 GMT

@ykasture , I belive you can try with tDenormalizem component . can you try with it?

Re: Convert Rows to Dynamic Columns with respective data

kuwaryogi27 — Mon, 11 Nov 2019 12:12:09 GMT

Hello @manodwhb ,
yes sure I am trying tDenormalize will update you in few minutes.

Re: Convert Rows to Dynamic Columns with respective data

kuwaryogi27 — Mon, 11 Nov 2019 12:16:22 GMT

Hello @manodwhb, tDenormalize is more often used with csv files and the output from tDenormalize will be static we want dynamic output. I guess we will need java code for that.

Re: Convert Rows to Dynamic Columns with respective data

manodwhb — Mon, 11 Nov 2019 12:31:58 GMT

@ykasture , You need java program and you need to include in talend to do the requirement.

Re: Convert Rows to Dynamic Columns with respective data

kuwaryogi27 — Mon, 11 Nov 2019 12:45:26 GMT

Hello @manodwhb , Can you help me with the java code?