Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
if I read multiple times it will affect performance and tunite can not join branches separated from same source/link
thanks instead of using hashfile component, can we do unpivot stage?