Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Data input rounding issue with XLSB file

HMSUM
7 - Meteor

I have a xlsb file.

 

When I load data with the file closed, the data load in Alteryx is rounded to Integer.

HMSUM_1-1621243797026.png

 

 

However, when I open the file (keep the file open in excel), and run the workflow again, the data load in Alteryx is with decimal amount.

HMSUM_0-1621243779840.png

 

What I expect is to have the bottom result (with decimal) even not opening the file. 

*** Assume no change to the source data

 

Attached my sample xlsb source and workflow, any one have same issue / workaround?

 

XLSB file (as Alteryx community not support xlsb file, so put in dropbox)

https://www.dropbox.com/scl/fi/vm3zbo3bgkjivt90mcrtz/test_for_alteryx.xlsb?dl=0&rlkey=hqj6jk8bpsa4vp...

2 REPLIES 2
dougperez
12 - Quasar

Try to convert the XLSB file to XLSX (use the macro in this thread: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Invalid-Argument-error-message-when-tr...)

 

 

HMSUM
7 - Meteor

Seems not working, the file corrupt after changing from xlsb to xlsx

Labels
Top Solution Authors