Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
I have an Excel file with multiple sheets, existence of those sheets are random. If a sheet is there, a series calculation will be perfomed based on the sheet data, if not, I wish there is a way to stop the workflow right away.
Is there a way to stop the workflow when workflow finds out a sheet does not exist like shown below?
Solved! Go to Solution.
Hi @yuanlu
Here is how you can do it.
1. Use the message tool like below. What the below message tool is doing is its checking recordnumber=1 exists (which means there is at least one row in false). If recordnumber=1 stop and error at that point.
2. Configure the workflow in the runtime tab to Cancel running the workflow on error.
Hope this helps : )
