Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

CSV inputs andautomatic rounding

BillyL14
8 - Asteroid

Hi there

I am inputting 2 csv files into my workflow. I am using CSV because I learnt that if your input are called Book 1 and Book 2, and if you specify Book ?, then the two sheets will come in together.  I know that CSV automatically treats all data as v_string type. I have a column full of numerical data which I used select tool to change to double. The problem that I am having is that there are numbers in with commas, like 1,250 (for clarification, = 1250), it is rounding this to 1 after changing to double. Is there any way to avoid this rounding?

 

Thanks

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @BillyL14 you would need to remove the comma before you convert the field to a double. I mocked up some approaches.

BillyL14
8 - Asteroid

Hi @JosephSerpis that worked great! thanks

Labels