Unpivot node

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:

image

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

Hello @stef_pf ,

try this:

Have a nice evening,
Raffaello Barri
LinkedIn

1 Like

Hi,

It seems good but:

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

Thank you for your reply.

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

Hello @stef_pf ,

I have made a small change in the previous workflow.

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

Have a nice day,
Raffaello

2 Likes

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

Hi,

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

image

I have this:

image

Thank you for your support.
BR.
Stef_pf

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.