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.
Is it possible to stop a workflow without using a macro?
I have a vendor that sends us a file via sFTP, however the time they send the file isn't consistent so this workflow runs every hour from 8am-11am. The problem that's happening is that the workflow is designed as follows:
Directory tool lists files in a folder
File info is passed to dynamic input to read the file
File is loaded into database (database is set to delete all data and append)
Now when there is no file,I would expect nothing to happen, but what ends up happening is Alteryx passes the metadata all the way to the output component which proceeds to delete the data. I want to delete the data but only if there's something to append, but if there is no file, then do not truncate the table. Any thoughts or ideas?
My concern with that approach is that I wouldn't be able to put email notifications on for actual errors, I mean I technically could, but then I'd keep reeving error notifications every hour that we did not received a file.
My issue is that I have to maintain the workflow in the gallery, and then maintain the macro somewhere else externally. Either way, I'm not against it, I'd just prefer not to use them if possible, but to your point I think I have no options here but to use a macro.
You cannot have macros used in workflow separatly in a network share. The underlying macros in workflow are packages and deployed to Gallery as part of workflow. That is the reason when a workflow is downloaded from gallery it is in .yxzp type.
This will be a problem when you want to maintain versions.