Data type error

Question

Hi, I am working on a workflow wherein I am using .xlsx input into Alteryx.

in the transaction number column, the amounts are showing as whole in the input file as shown below.

where in when i take this file as input in Alteryx, the transaction number is showing as an errored column, as shown below

Any help on how to solve this?

caltang · Answer

If you can provide some sample data, then that would be great. Otherwise what @FrederikE said is valid. You can standardise the data type in Alteryx but if it reads numbers scientifically and as strings then that’s a problem.

caltang · Answer

Off topic - you can use the snip tool to get your images clean and crisp. Your pics are too blurry I can’t see it properly…

FrederikE · Answer

Hey @Tid14,

I'd say that is more of an Excel topic than Alteryx. Excel is saving it as a number, although it should be a string- make sure to save it as a text and Alteryx will read it correctly. Otherwise, change the data type to string in Alteryx afterwards.