# Integer to Double - Maybe a small bug in KNIME?

**URL:** <https://forum.knime.com/t/integer-to-double-maybe-a-small-bug-in-knime/2200>\
**Category:** KNIME Analytics Platform\
**Created:** [March 6, 2013, 8:56am UTC](https://forum.knime.com/t/integer-to-double-maybe-a-small-bug-in-knime/2200 "2013-03-06T08:56:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ImNotGoodSry](https://forum-cdn.knime.com/user_avatar/forum.knime.com/imnotgoodsry/32/470_2.png) [@ImNotGoodSry](https://forum.knime.com/u/ImNotGoodSry)\
**Post date:** [March 6, 2013, 8:56am UTC](https://forum.knime.com/t/integer-to-double-maybe-a-small-bug-in-knime/2200/1 "2013-03-06T08:56:16Z")

</div>

Hey folks,  
  
 today I made a few changes to a workflow I have been using for a while. To make a long story short, one column needed to be changed from integer to double.  
  
 First I did that with the _Column Rename_ node. The output seemed to be okay, but the _Z-Primes_ node from the _HCS Tools_ threw a error message (Execute failed: Could not cast attribute Value (null) to double. Use the String2Number node to convert the type).  
  
 Then I tried the&nbsp;_Math Formula_ node to convert the column from integer to double. The node output equals the _Column Rename_ node's output in every little detail. But, guess what! The _Z-Primes_ node works perfectly fine.  
  
 I hope this information might help you to identify a possible bug within KNIME.  
  
 Have a nice day!

---

<div class="post-metadata">

**Author:** ![thor](https://forum-cdn.knime.com/user_avatar/forum.knime.com/thor/32/4_2.png) [@thor](https://forum.knime.com/u/thor)\
**Post date:** [March 6, 2013, 9:51am UTC](https://forum.knime.com/t/integer-to-double-maybe-a-small-bug-in-knime/2200/2 "2013-03-06T09:51:21Z")

</div>

This looks more like a problem in the Z-Primes nodes. The Column Rename just changes the type of the column but does not touch the values itself. This should not affect the downstream nodes, though. They can just use the double representation of the integers in the column. The Math Formula creates a new column with real doubles in it. But it really shouldn't matter for other nodes.

---

<div class="post-metadata">

**Author:** ![stoeter](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/ecd19e/32.png) [@stoeter](https://forum.knime.com/u/stoeter)\
**Post date:** [March 6, 2013, 6:42pm UTC](https://forum.knime.com/t/integer-to-double-maybe-a-small-bug-in-knime/2200/3 "2013-03-06T18:42:56Z")

</div>

Hi,

I could reproduce this error. The problem seems to be the convertion of integer to double using the Rename Node. The table actually displayes it as a "double", but if you go to the Spec tab and see the domain, then it shows a "Non-Native" data. I always try to avoid this data type, because I often have problems with it and it seems that the Z-Primes node also has problems handling it and throws this error.

I just tried two KNIME nodes using this "Non-Native" double column and the Math Node has no problem with this data type. The String Manipulator also works, but the column converted to double using Math Node as string gives e.g. "1234.0", whereas the one converted using the Rename Node gives "1234". So it seems that it is not really treated as a double data type as Thor already mentioned, the values stay integers.

I think you should not use the Rename Node to convert integer to double.

Martin

---

<div class="post-metadata">

**Author:** ![stoeter](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/ecd19e/32.png) [@stoeter](https://forum.knime.com/u/stoeter)\
**Post date:** [March 6, 2013, 6:45pm UTC](https://forum.knime.com/t/integer-to-double-maybe-a-small-bug-in-knime/2200/4 "2013-03-06T18:45:19Z")

</div>

We will see if be can fix the Z-primes node to accept this type of columns with the next release...

Martin&nbsp;

---

<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:17pm UTC](https://forum.knime.com/t/integer-to-double-maybe-a-small-bug-in-knime/2200/5 "2023-06-23T20:17:29Z")

</div>


