I want to combine the Values of Row0 and Row1 and then manipulate the String.
Row1 stat inv qty
Row3 qty 2004
Row0 and Row1 can be deleted afterwards.
I was able to build a process that transform the following:
thru this workflow
It looks like the workflow is a bit complicated and I would appreciate any help. Thanks
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?
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.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.