Unpivot node

[stef_pf]

Hi all,

I have this input file. I would like to know if there is a better way to get my result.
I can’t insert the matching groups.

Input file:

Result:

Any suggestion?
Thanks in advance.
Best Regard
Unpivot.knwf (54.9 KB)

[lelloba]

Hello @stef_pf ,

try this:

Unpivot node – lelloba

Have a nice evening,
Raffaello Barri
LinkedIn

[stef_pf]

Hi,

It seems good but:

It doesn’t have to be “code”, is there another way?

Thank you for your reply.

[stef_pf]

Hi,

Below:

I prefer to keep a table and map the file to it.

Designation	Reference	Items
Headers4	AFNxxx	Group2
Headers5	INFxxx	Group2
Headers6	THJxxx	Group2
Headers7	INFxxx	Group3
Headers8	UJYxxx	Group3
Headers9	THJxxx	Group4
Headers10	AFNxxx	Group4

Thank you in advance for your reply.
Stef

[lelloba]

Hello @stef_pf ,

I have made a small change in the previous workflow.

Unpivot node – lelloba

Now it works event without looking for the word “code”.

Have a nice day,
Raffaello

[stef_pf]

Hi,

Sounds good, I’m trying it today with the real inputs. I have another file that has extra columns that I also need to add.
I also need to add a total row after concatene data.
Thank you.
Stef_pf

[stef_pf]

Hi,

I have another difficulty, here you filter by “Header*”

I have this:

Thank you for your support.
BR.
Stef_pf