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!

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels