Can I stop a workflow without a macro if no file is detected?

Question

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?

PARESH · Answer

I checked the link but I am still not getting answer, I want to stop workfllow after a filer tool if there are no records.

gnans19 · Answer

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.

adm510 · Answer

@gnans19

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.