Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

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