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

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.

Input

Accepted answers

DawnDuong

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-Excel-Macro/ba-p/9988

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/listing-list-of-sheet-names-of-xlsb-file/td-p/738315

hope it works for you.
Dawn.

Dawn.

All comments

ArtApa

Hi @NiallJ - Data samples would help.

DawnDuong

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-Excel-Macro/ba-p/9988

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/listing-list-of-sheet-names-of-xlsb-file/td-p/738315

hope it works for you.
Dawn.

Dawn.

NiallJ

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335