Avoid the Dynamic tool error if the Input file is not found

I have a workflow that processes two types of files "separately" because their data needs to be cleaned differently and then joins them. However, it could happen that one of the two data sets is missing, but I would like to be able to run the workflow anyway and avoid the Dynamic tool error that I get in case the file is not found. I would like to avoid using Macros though.

The logic of my workflow is not that complicated and looks like the following.

Any help or tips would be highly appreciated!

Workflow

Datasets

Input

Preparation

Accepted answers

IraWatt

Hey @danbzz,

I'm sure there must be a smarter work around but you can add in a dummy file. This ensures that there will be a column to join on so that the join doesn't error:

Give it a try

Any questions or issues please ask
HTH!
Ira

Workflow0506.yxmd

All comments

IraWatt

Hey @danbzz,

I'm sure there must be a smarter work around but you can add in a dummy file. This ensures that there will be a column to join on so that the join doesn't error:

Give it a try

Any questions or issues please ask
HTH!
Ira

Workflow0506.yxmd

danbzz

hey @IraWatt - thanks for your reply! Unfortunately, the error is related to Dynamic Input not finding the file within the input folder, and not from the join. The workflow stops before it gets to that point (pls see below).

This is because the 2 datasets can both be present at the same time, one missing and the other not, and vice versa. And in case one of them is missing, the workflow generates an error. Would you have any other ideas?

IraWatt

@danbzz you workflow in the configuration I gave will still run if the dynamic input tool errors. So long as this option in the runtime configuration is ticket it will still run.

You can check this be seeing if data is still being passed to the join if only one dynamic input has data.

danbzz

@IraWatt oh got it! So, basically, the workflow will run regardless of the missing files and will throw an error when completed, right? Wouldn't that be confusing? Do you think it is possible to customize the error message?

IraWatt

Yeah @danbzz that's the idea. I don't think its possible to overwrite or stop the Dynamic input from erroring however you can create you own message on top of it to explain:

. Have you considered using a directory tool to check the files exist before the dynamic input?

Workflow0506.yxmd

danbzz

@IraWatt yeah, I am using the directory and filter tools to check the existence of the files before trying to open them with the Dynamic Input tool, but unfortunately, Alteryx keeps generating the error in case the file does not exists. I assume therefore that there is no way to avoid the error.

GMurphy

I have the same need.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335