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)
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*”
I have this:
Thank you for your support.
BR.
Stef_pf