I have a xlsb file.
When I load data with the file closed, the data load in Alteryx is rounded to Integer.
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.
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)
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...)
Seems not working, the file corrupt after changing from xlsb to xlsx