ETL: Combine Values of 2 Rows

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
combine

thru this workflow

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

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

3 Likes

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 :smiley:

3 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.