# Unpivot node **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [November 7, 2023, 4:10pm UTC](https://forum.knime.com/t/unpivot-node/75053 "2023-11-07T16:10:49Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![stef\_pf](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/cc9497/32.png) [@stef\_pf](https://forum.knime.com/u/stef_pf)\ **Post date:** [November 7, 2023, 4:10pm UTC](https://forum.knime.com/t/unpivot-node/75053/1 "2023-11-07T16:10:50Z")
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: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/c/5/c558e09c56cabe0c022730295134d9df5f7b79c6.png) Result: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/2/5/25bc15edebeadbc9389a432ee7feed6cc183abd4.png) Any suggestion? Thanks in advance. Best Regard [Unpivot.knwf](https://forum.knime.com/uploads/short-url/fTz0sJ8xWOIHYfPPIUngMHU5U38.knwf) (54.9 KB) ---
**Author:** ![lelloba](https://forum-cdn.knime.com/user_avatar/forum.knime.com/lelloba/32/43992_2.png) [@lelloba](https://forum.knime.com/u/lelloba)\ **Post date:** [November 7, 2023, 5:15pm UTC](https://forum.knime.com/t/unpivot-node/75053/2 "2023-11-07T17:15:13Z")
Hello @stef_pf , try this: > **[Unpivot node – lelloba](https://hub.knime.com/lelloba/spaces/Forum/Unpivot%20node~GHSpfdUYVtrOQ22x/current-state)** > > Solutions for data science: find workflows, nodes and components, and collaborate in spaces. Have a nice evening, Raffaello Barri [LinkedIn](https://www.linkedin.com/in/raffaellobarri/) ---
**Author:** ![stef\_pf](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/cc9497/32.png) [@stef\_pf](https://forum.knime.com/u/stef_pf)\ **Post date:** [November 7, 2023, 9:16pm UTC](https://forum.knime.com/t/unpivot-node/75053/3 "2023-11-07T21:16:54Z")
Hi, It seems good but: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/8/4/84ad5033a4327290a562c57e7a6b1554031e63c5.png) It doesn’t have to be “code”, is there another way? Thank you for your reply. ---
**Author:** ![stef\_pf](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/cc9497/32.png) [@stef\_pf](https://forum.knime.com/u/stef_pf)\ **Post date:** [November 7, 2023, 11:10pm UTC](https://forum.knime.com/t/unpivot-node/75053/4 "2023-11-07T23:10:29Z")
Hi, Below: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/1/d/1d9c41b7707f10b2f4f74273ac34ce9e4b336fb9.png) 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 ---
**Author:** ![lelloba](https://forum-cdn.knime.com/user_avatar/forum.knime.com/lelloba/32/43992_2.png) [@lelloba](https://forum.knime.com/u/lelloba)\ **Post date:** [November 8, 2023, 1:22pm UTC](https://forum.knime.com/t/unpivot-node/75053/5 "2023-11-08T13:22:09Z")
Hello @stef_pf , I have made a small change in the previous workflow. > **[Unpivot node – lelloba](https://hub.knime.com/lelloba/spaces/Forum/Unpivot%20node~GHSpfdUYVtrOQ22x/current-state)** > > Solutions for data science: find workflows, nodes and components, and collaborate in spaces. Now it works event without looking for the word “code”. Have a nice day, Raffaello ---
**Author:** ![stef\_pf](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/cc9497/32.png) [@stef\_pf](https://forum.knime.com/u/stef_pf)\ **Post date:** [November 8, 2023, 4:04pm UTC](https://forum.knime.com/t/unpivot-node/75053/6 "2023-11-08T16:04:22Z")
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 ---
**Author:** ![stef\_pf](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/cc9497/32.png) [@stef\_pf](https://forum.knime.com/u/stef_pf)\ **Post date:** [November 9, 2023, 4:38pm UTC](https://forum.knime.com/t/unpivot-node/75053/7 "2023-11-09T16:38:03Z")
Hi, I have another difficulty, here you filter by “Header\*” ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/e/3ec07967ae907ae737c2ea06ed96c1bdb0240aaf.png) I have this: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/6/4/64d04399224b5f29dbfef749c757a9b1a07a34e8.png) Thank you for your support. BR. Stef\_pf ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [December 1, 2023, 7:24pm UTC](https://forum.knime.com/t/unpivot-node/75053/8 "2023-12-01T19:24:57Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.