V-String formatting for all excel sheets

[sericson]

I am trying to format all excel files and all sheets to come into Alteryx as v-string, is there a way to do this in the excel file or when bringing into Alteryx? The same file can come over as several columns being v-string or double and then switch the next time it gets brought into Alteryx. I need them to be consistently v-string. 

[DataNath · Accepted solution]

Hey @sericson, one of the configuration options in the Multi-Field Formula tool is changing the outgoing data types of fields and so we can just run every field through this, keep it as is and change the output to a v_string. I've attached a workflow - just replace the input file with the one you want to use!

[caltang]

Just to add to @DataNath - you can also do some feature engineering by changing empty values into nulls with IF IsEmpty() then Null() Else currentfield endif. 

Helps speed up the process down the road!

[sericson]

Thank you both so much for your help! this worked out perfectly!