Number dropping off when importing data from CSV

[alexanderjen]

Hi all, 

I have specified a CSV file as the input data. Subsequently, I am using Select to format the field as Type = Double. 

However, it appears the value of numbers is dropping off after the comma; in other words 123,000 becomes 123.

I can't seem to figure out why. This doesn't seem to be a problem when my input data is in xlsx format. Am I not specifying something correctly when I import the csv file?

Thanks,

[LordNeilLord · Accepted solution]

Hey @alexanderjen

It looks like your amount column has been stored as text in the csv (the 1000 separator is visible).

Before you convert to a double, use the formula tool to remove the commas: Replace([Amount], ",","")....this will replace the commas with nothing and then you can convert.

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

 

[alexanderjen]

Makes so much sense now that you've brought it to light.

Thanks!