Hi,
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
This format.
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.
Thanks.
HansS
January 19, 2021, 10:03am
2
Hi @Braveen
See this wf: customized_table_format.knwf (24.4 KB) . It uses a Unpivoting node inside a Group Loop.
gr. Hans
3 Likes
Braveen
January 19, 2021, 10:29am
3
Thank you, This will do.
BTW, I want to learn more about Loops and many more nodes, how do I do that? Any suggestion?
1 Like
HansS
January 19, 2021, 10:42am
4
4 Likes
@Braveen I have this collection about Loops and similar items
For loops you might want to take a look at these links:
2 Likes
Great work HansS.
Any particular reason for using the Group loop instead of only unpivoting?
Thanks
5 Likes
HansS
January 21, 2021, 7:08pm
7
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
gr, Hans
4 Likes
system
Closed
January 28, 2021, 7:08pm
8
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.