Alteryx Processing Input Data With Incorrect Values

pateldev22

I have a named range set up in excel for a data set which Alteryx is reading via an input tool, however the value of the field is showing up as a number rather than the value itself within Excel. Does anyone know what can be causing this and what the resolution can be?

I've attached screenshots for review.

Alteryx Capture.PNG

Excel Named Range and Valeu.PNG

danilang

Hi @pateldev22 

It sounds like you need to "harden" your batch macro to deal with inconsistencies in your input data.  It's a common problem that we run across at some point.  It's especially common when dealing with Excel files since users have free reign to modify the files as they see fit.  Since extra data is almost always easier to deal with than missing data, you could modify your macro to include @Qiu's fix and then add some validation to check if the 1st row is your header row, SBU, Account Group, etc.  If it's not then use a Dynamic Rename to take the headers from the first row of data. 

Dan