This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
I am working on a use case where I am reading multiple csv files with different schemas using macros.
Ex. Type A has 22 files with same schema Type B has 22 files with same schema
I would like to export all the 44 files into 44 sheets in a single excel file, where the file name has to be shown as sheet name in excel. I am able to achieve the scenario using macros and am able to successfully run the alteryx workflow as well. But when I try to open the consolidated excel file. I get the following error:
" We found a problem with some content in 'Output2.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."
This is a common issue with excel outputs, especially if you are writing to an existing file. While your workflow will run successfully with no errors, the problem occurs when opening said excel file. The bad news is that there isn't really a way to fix this by altering your workflow. This post talks more about this issue and has some advice on how to fix it.