topic Re: unpivot or tunite option in Talend Studio

unpivot or tunite option

Anonymous — Sat, 16 Nov 2024 02:53:24 GMT

Input file

ID,firstName1, firstName2, firstName3 , LastName1, LastName2, LastName3, Amount1,Amount2,Amount3, Date

1,FN1,FN2,FN3,LN1,LN2,LN3,10,20,30,3/24/2020

Output file

ID , Number , firstName , LastName , Amount , Date

1, 1, FN1, LN1, 10, 3/24/2020

1, 2, FN2, LN2, 20, 3/24/2020

1, 3, FN3, LN3, 30, 3/24/2020

Please share which components to use.

Re: unpivot or tunite option

manodwhb — Wed, 25 Mar 2020 02:13:21 GMT

One way is you need to read mutipule times use tmap or tjavarow and get requireed columns and then use tunite to union.

Re: unpivot or tunite option

Anonymous — Wed, 25 Mar 2020 02:46:40 GMT

if I read multiple times it will affect performance and tunite can not join branches separated from same source/link

Re: unpivot or tunite option

manodwhb — Wed, 25 Mar 2020 02:50:37 GMT

Yes it will impact the performance, read that and use replicate and then use the thasouputs . then you read the data using thashinputs and then you can use tunite component to do union all operation.

Re: unpivot or tunite option

Anonymous — Wed, 25 Mar 2020 13:30:07 GMT

thanks instead of using hashfile component, can we do unpivot stage?

Re: unpivot or tunite option

manodwhb — Wed, 25 Mar 2020 15:02:40 GMT

With unpivot component you will not achieve this scenario.