# Column Conversion

**URL:** <https://forum.knime.com/t/column-conversion/70497>\
**Category:** KNIME Analytics Platform\
**Created:** [July 12, 2023, 5:46am UTC](https://forum.knime.com/t/column-conversion/70497 "2023-07-12T05:46:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Banksy](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/b/ad7895/32.png) [@Banksy](https://forum.knime.com/u/Banksy)\
**Post date:** [July 12, 2023, 5:46am UTC](https://forum.knime.com/t/column-conversion/70497/1 "2023-07-12T05:46:54Z")

</div>

Hello everyone，  
As the column name “FY2223 Sep LC” is a variable, and the number of columns is too large, so I can not use joiner, how to solve this problem, thank you!

From  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/b/3/b375c152bf9a1a9fe3d1fab3952904de12624eaa.png)

To  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/f/3/f328312bbc1a63e36dec1bd57a0a8a27f2893778.png)

---

<div class="post-metadata">

**Author:** ![takbb](https://forum-cdn.knime.com/user_avatar/forum.knime.com/takbb/32/57077_2.png) [@takbb](https://forum.knime.com/u/takbb)\
**Post date:** [July 12, 2023, 7:02am UTC](https://forum.knime.com/t/column-conversion/70497/2 "2023-07-12T07:02:27Z")

</div>

Hi @Banksy ,

The Unpivoting node should put you in the right direction.

Specify the “Number” column as a “Retained column”, and all the other columns as “Value columns”, then afterwards you will probably just need to re-sort the column order to what you require.

(The “FYxxxx” columns will appear in a column called “ColumnNames” and the numeric values will appear in a column called “ColumnValues”)

---

<div class="post-metadata">

**Author:** ![Banksy](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/b/ad7895/32.png) [@Banksy](https://forum.knime.com/u/Banksy)\
**Post date:** [July 12, 2023, 7:29am UTC](https://forum.knime.com/t/column-conversion/70497/3 "2023-07-12T07:29:10Z")

</div>

Hi @takbb ,  
Nice to meet you again.  
Thank you so much my master, you help me always.

---

<div class="post-metadata">

**Author:** ![takbb](https://forum-cdn.knime.com/user_avatar/forum.knime.com/takbb/32/57077_2.png) [@takbb](https://forum.knime.com/u/takbb)\
**Post date:** [July 12, 2023, 8:36am UTC](https://forum.knime.com/t/column-conversion/70497/4 "2023-07-12T08:36:11Z")

</div>

lol, you’re welcome @Banksy and nice to see you again too. And thanks for marking my answer as the solution.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [July 19, 2023, 8:36am UTC](https://forum.knime.com/t/column-conversion/70497/5 "2023-07-19T08:36:33Z")

</div>

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