ETL: Combine Values of 2 Rows

[sven-abx]

Hi there,

I want to combine the Values of Row0 and Row1 and then manipulate the String.
Example:
Row0 2004
Row1 stat inv qty
Result:
Row3 qty 2004

Row0 and Row1 can be deleted afterwards.

I was able to build a process that transform the following:

to

thru this workflow

It looks like the workflow is a bit complicated and I would appreciate any help. Thanks

[AlexanderFillbrunn]

Hi,
it looks like your data also makes sense if you use the values of Col0 as columns and transpose the table. Could you use the RowID node to make column Col0 into a RowID, then Transpose the table so they become columns and then use a String Manipulation node to generate your desired result?
Kind regards
Alexander

[sven-abx]

Hi Alexander,

thanks for your help. Your post reminded me to give RowID and Transpose a second try and it worked out. I think I’m on a good way to get my Workflow going to produce the desired outcome.

Thanks