Alteryx Designer Desktop Discussions

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

String to Numeric Changing Field Values?

ScottWW
5 - Atom

I am working with a dataset from a CSV file. Perhaps the fact that it is a CSV and not a XLSX is the answer to my question, though I am still curious as to why this is happening. 

 

I attached two screenshots so everyone can see what's happening: The Field "Base Market Val" is a string, but I need to convert it to numeric to run formulas with the values. After the Select Tool is used to change from V_String to Double, the values in the field changes. 

 

Can someone please explain why this is happening?Alteryx Q1.jpgAlteryx Q2.jpg

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @ScottWW the issue is your field has commas if you remove them then convert to a numeric field then the values won't change. 

ScottWW
5 - Atom

Makes sense, I figured it was something simple like that. Thanks!

Labels