Hello everyone，
As the column name “FY2223 Sep LC” is a variable, and the number of columns is too large, so I can not use joiner, how to solve this problem, thank you!
From
To
Hi @Banksy ,
The Unpivoting node should put you in the right direction.
Specify the “Number” column as a “Retained column”, and all the other columns as “Value columns”, then afterwards you will probably just need to re-sort the column order to what you require.
(The “FYxxxx” columns will appear in a column called “ColumnNames” and the numeric values will appear in a column called “ColumnValues”)
3 Likes
Hi @takbb ,
Nice to meet you again.
Thank you so much my master, you help me always.
lol, you’re welcome @Banksy and nice to see you again too. And thanks for marking my answer as the solution.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.