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.
We have an Alteryx built off of one Excel with 42 different tabs. These tabs are all a bit different so we cannot use a Dynamic Input. The problem we are having is that if one of the tabs is missing in this Excel, the entire Excel crashes because it cannot find the specified file path. Is there a way to do some sort of an "if" statement on the input that lets that Alteryx know to continue with the other functions on the page and ignore that function if the tab does not exist?
I do take a list of sheet names. Each input is already set up as one of the sheet names but we want to be able to run it if only 2 of the sheets are actually present without having to change the inputs every time we go to run the Alteryx. How do we go about preventing it from running that part of the workflow? Thank you!
@kkaplan1Please see attached for a variety of options to bring multiple Excel files together into 1. The solution is dependent on the set up of the Excel files (same schema, different schema, same sheet names, different sheet names, sheet sequence number, etc). You mention "These tabs are all a bit different so we cannot use a Dynamic Input". Why? How are they different and how are you bringing them together? If you could send a pic of the workflow, that may help me understand.
Hopefully one of the attached samples will help you out. Let me know if one of these works for you!
You might consider the Tool Container. It has an Enable/Disable switch on it, so if you put something like a "subroutine" in it, you can effectively prevent that portion of the workflow from running altogether based on some rules that you set.