I have a strange requirement. I have attached images below for a better visual.
I have a data which looks like below image and I need this to transform it to
I tried to use Extract column header, Cross join with ABC. But, I some how can’t relate to the logic of getting the number based on two reference.
Appreciate you help and time.
See this wf: customized_table_format.knwf (24.4 KB) . It uses a Unpivoting node inside a Group Loop.
Thank you, This will do.
BTW, I want to learn more about Loops and many more nodes, how do I do that? Any suggestion?
@Braveen I have this collection about Loops and similar items
For loops you might want to take a look at these links:
Great work HansS.
Any particular reason for using the Group loop instead of only unpivoting?
I picked the Group Loop because I thought I had to create something for every element in the first column. Some kind of intuition.
But now when I check the outcome just the Unpivot node will do. Tnx for asking @Daniel_Weikert
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.