Bug with Dynamic Input Tool and xlsb Files

[felixlam]

Hi all,

I recently upgraded my Alteryx to 2023.1 because I deal with xlsb files at work and needed them to be read into Alteryx. To do so, I also downloaded an Access Driver to facilitate the reading in of these files. It works wonderfully, however only in small sets. On my workflow, I have a large number of dynamic input tools and when I run them in separate workflows, they read in the xlsb files perfectly but when they are all in the same workflow, they produced the error message "You have found a bug". My workaround so far has been to put the dynamic input tools into macros and for the most part it will work fine. But now that solution does not work either or it will work sometimes but other times pops out that error message. Also just for reference, the error occurs on the Dynamic Input tool. If the Alteryx team or anyone else can assist, that would be greatly appreciated.

Thank you!

[aatalai]

@felixlam could this from the market place be a work around/? https://marketplace.alteryx.com/en-US/apps/430452/excel-hoover

[albert_alaluf]

Hi @felixlam 

Generally speaking when I get an error such as 'You have found a bug', I do as follows;

- Save the workflow, and restart Alteryx

or

- Uncheck Use AMP Engine

or 

- Create a new workflow.

I cannot explain why 'You have found a bug' appears and it happens to me any other time. When I try something as above, the problem disappears. Also I reach to Alteryx Support to get some help.

Did you also try to convert Binary Excel to xlsx? The only difference is the binary will compress your data which gonna be smaller excel file, but it may work.