topic Transpose in Talend Studio

Transpose

Anonymous — Thu, 07 Nov 2019 12:25:05 GMT

Based on the Flag active status we need to fill the appropriate description columns like the below given output. It’s like transpose of rows to column based on a key value.

For example

Input file:

Id	Flag1	Flag2	Flag1_desc1	Falg1_desc2	Flag2_desc1	Flag2_desc2
1	1	0	abc	abc
2	0	1			abc	abc
3	1	1	abc	abc	abc	abc

Output:

Id	Flag	Desc1	Desc2
1	Flag 1	abc	abc
2	Flag2	abc	abc
3	Flag1	abc	abc
3	Flag2	abc	abc

Thanks in advance

Re: Transpose

manodwhb — Fri, 08 Nov 2019 05:23:14 GMT

@saravanan_ehkn , please check the below link.

https://www.youtube.com/watch?v=6qTD4s3wu9c

Re: Transpose

Anonymous — Mon, 11 Nov 2019 08:00:41 GMT

hi manohar,

Thanks for your reply but actually it is not transpose of rows to column some logic is there can you please help me out

29_day.csv

Re: Transpose

manodwhb — Mon, 11 Nov 2019 09:22:40 GMT

@saravanan_ehkn ,check the below solution.