Customized table format

[Braveen]

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]

Hi @Braveen

See this wf: customized_table_format.knwf (24.4 KB) . It uses a Unpivoting node inside a Group Loop.

gr. Hans

[Braveen]

Thank you, This will do.

BTW, I want to learn more about Loops and many more nodes, how do I do that? Any suggestion?

[HansS]

Hi @Braveen

See e.g. https://www.knime.com/nodeguide/control-structures/loops
And / Or do some searches on the Hub https://hub.knime.com/
gr. Hans

[mlauber71]

@Braveen I have this collection about Loops and similar items

A meta collection about Loops, Switches, Paths and Flow Variables in KNIME...

For loops you might want to take a look at these links:

How to include file CSV Writer in a loop?

Hi @braunnz and welcome to the KNIME community forum, You can find your answer here (and learn more about loops in KNIME): https://blog.statinfer.com/which-loop-is-the-right-one-for-me/ And here you can learn more about making use of flow variables in KNIME: https://blog.statinfer.com/knime-spirits-at-your-service/

[Daniel_Weikert]

Great work HansS.
Any particular reason for using the Group loop instead of only unpivoting?
Thanks

[HansS]

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