Text input is being changed to a number in Alteryx

Question

Hi all,

I've input data from an specified range in my excel file. I have a column "Heading" with text in it. However when this is input into Alteryx it is being recognized as a number. For example, in excel it reads "profit before tax" but in Alteryx it reads "92". Would anyone be able to explain what is causing this and how to fix it.

This is all before I have done anything to the data once in alteryx.

Thanks,

MichaelSu · Answer

Hi @bieltd ,

You may want to check to see that the extension is .xlsx as well and not an older Excel file type.

Thanks,

Mike

atcodedog05 · Answer

Hi @bieltd

Just a rough guess. Make sure the start import from line is from the header row.

This might have got configured to 2 or data row which has been taken as column name.

If this is not the issue please provide sample data file. We will be happy to help.

Hope this helps : )

dougperez · Answer

Can you provide the input file to me?