Convert a delimited file to SQL

[rsullivan]

Working on my first workflow on Alteryx 10.5 which is processing a ";" delimited file and exporting the file
into a SQL 2012 database.  I am applying a formula to add a date processed field and change 2 fields to date and one

 currency field to a double. I have the process running and loading the proper table but my totals are
off and I see an workflow message of error ConvError: Select (4): Field_9: 1,261.97 stopped converting
at a comma on the currency field.

[MarqueeCrew · Accepted solution]

Replace([field],",","")

You are reading a text field in as numeric and the only values allowed are 0-9 and a period. Get rid of the comma and you'll be fine.

[RodL]

@MarqueeCrew, hey wait a minute...isn't it Friday??? 

[MarqueeCrew]

Erase. Erase.

[rsullivan]

This worked perfect thank you