Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Value fields in CSV Input Data

pliskers_dup_528
7 - Meteor

I load a large CSV file into a workflow.  There are numerous string fields in the CSV, moving from left to right, followed by 4 fields of values, and with one string field at the right end.  When I look at the metadata for the input data, all fields are appearing as VString fields.  

 

Do I need to be concerned about this, or will the values in the fields shown as VString be properly treated as values?  Do I need to use the ToNumber function on all of the value fields?  I tried that, but in the output from the formula the numeric fields still appear as VString.

 

I'm relatively new to Alteryx and appreciate any input as I develop my ways of working.

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

Try using an AUTO FIELD tool after the input.  There is a Tool Mastery document here to help guide you.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
pliskers_dup_528
7 - Meteor

Thank you.  A more experienced coworker also suggested that I use the Select Tool rather than a formula.  I just changed the field type in the Select Tool to Double and everything seems OK now.

Labels