unpivot or tunite option

[Anonymous]

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.

[manodwhb]

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

[Anonymous]

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

[manodwhb]

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.

[Anonymous]

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

[manodwhb]

With unpivot component you will not achieve this scenario.