Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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