# Changing Nominal Value Datatype to String, Int, or Double

**URL:** <https://forum.knime.com/t/changing-nominal-value-datatype-to-string-int-or-double/6675>\
**Category:** KNIME Analytics Platform\
**Created:** [September 16, 2014, 9:19pm UTC](https://forum.knime.com/t/changing-nominal-value-datatype-to-string-int-or-double/6675 "2014-09-16T21:19:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![JM\_Ochoada](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/j/dfb087/32.png) [@JM\_Ochoada](https://forum.knime.com/u/JM_Ochoada)\
**Post date:** [September 16, 2014, 9:19pm UTC](https://forum.knime.com/t/changing-nominal-value-datatype-to-string-int-or-double/6675/1 "2014-09-16T21:19:17Z")

</div>

Hi everyone,

I have an workflow that pivots data into a large table. &nbsp;The resulting table has a number of columns which are of the nominal datatype. &nbsp;Depending on choices made in the workflow the number of columns can change.

Is there a way to use a Column Rename node (or any other node) to force all column types to String? &nbsp;Similar to the include all columns function in a string to number node?

If I can do that then I can use splitters to parce the columns and set the proper type.

Any ideas?

Thanks,  
Jason

---

<div class="post-metadata">

**Author:** ![aborg](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/a/c89c15/32.png) [@aborg](https://forum.knime.com/u/aborg)\
**Post date:** [September 16, 2014, 11:05pm UTC](https://forum.knime.com/t/changing-nominal-value-datatype-to-string-int-or-double/6675/2 "2014-09-16T23:05:23Z")

</div>

If I understand you correctly, you might be looking for the String Manipulator's string function. Probably followed by a Domain Calculator. This only works for a single column, so a loop through the columns is necessary.

Cheers, gabor

---

<div class="post-metadata">

**Author:** ![richards99](https://forum-cdn.knime.com/user_avatar/forum.knime.com/richards99/32/48547_2.png) [@richards99](https://forum.knime.com/u/richards99)\
**Post date:** [September 17, 2014, 11:05am UTC](https://forum.knime.com/t/changing-nominal-value-datatype-to-string-int-or-double/6675/3 "2014-09-17T11:05:14Z")

</div>

The only method I know is Gabor's method.

You will need a

Column List Loop Start, (Include All Columns)

Column Rename (RegEx), (Choosing Replacement as Test)

String Manipulation, (Using String ($Test$))

Column Rename (RegEx), (Choosing Search String as Test, and Replacement as the ColumnName Variable)

Loop End (Column Append)

&nbsp;

Simon.

---

<div class="post-metadata">

**Author:** ![JM\_Ochoada](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/j/dfb087/32.png) [@JM\_Ochoada](https://forum.knime.com/u/JM_Ochoada)\
**Post date:** [October 10, 2014, 7:56pm UTC](https://forum.knime.com/t/changing-nominal-value-datatype-to-string-int-or-double/6675/4 "2014-10-10T19:56:26Z")

</div>

Thanks Guys!

---

<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:** [June 23, 2023, 8:23pm UTC](https://forum.knime.com/t/changing-nominal-value-datatype-to-string-int-or-double/6675/5 "2023-06-23T20:23:34Z")

</div>