.xslb file that contains data, but alteryx makes them [null]

[thatsameguy]

Hi guys, Im new to Alteryx, and have been having trouble with some .xslb files.

I have a column that contains data (ex: X33, X41, and 541) when i open it on excel, but when I import the file to alteryx it only appears "541", while the other ones appear [null]. I know that those fields are not nulls, but alteryx seems to have trouble reading the fields with X33, X41 and the other ones...

Can someone please help me?? When i import the fale as .xls it works perfectly, but i wanted to use .xslb files, since they are much smaller...

Evidence:

on excel: 

on alteryx: 

[Sntrada · Accepted solution]

Hi @thatsameguy ,

Figured that might be the issue. 

I found this walkaround here -: https://community.alteryx.com/t5/Alteryx-Designer/Force-data-type-of-input-data/idi-p/24656

After you check the box for option 6, it seems Alteryx then forces all columns to be in string data type. You can then create appropriate column names, set appropriate variables, and drop the first row. 

Example pictured and attached. 

Hope this helps!