Designer - Issue loading XLSB Files (Decimal places are dropped off Numeric Fields)

[NiallJ]

To load more than one XLSB file using Wildcard I'm forced to tick "first row contains data" (if I don't only the first file loads) but when I tick "first row contains data" it only loads the number of decimal places that are visible on the file for numeric fields not the whole number. 

I've seen this issue discussed on here and solutions suggested for xls files but I haven't seen anything that works for xlsb files.

At the moment I've manually converting to xlsx but was just wondering of anybody had come across this and solved it.

[ArtApa]

Hi @NiallJ - Data samples would help. 

[DawnDuong · Accepted solution]

Hi @NiallJ 

Have you tried batch macro instead of the wildcard? The only issue is that the xlsb does not support the "input list of sheet names" which there are some workaround solutions that others had done:

https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Exc...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/listing-list-of-sheet-names-of-xlsb-fi...

hope it works for you.
Dawn.

Dawn.

[NiallJ]

Hi Dawn - that's looks like it'll work. Thanks for your help.