How to by pass part of workflow if File does not exists

Akshay_Wadikar

Hello All,

I have multiple different input files with each files own set of logic built, i want to check if file exists or not.

If file1 exists then Process_FILE1_LOGIC else SKIP_FILE1LOGIC

if file2 exists then Process_FILE2_LOGIC else SKIP_FILE2LOGIC

Process common part of workflow every time.

Thanks for your help in advance.

Developer Tools

Input

Dynamic Processing

Accepted answers

All comments

AngelosPachis

Hi @Akshay_Wadikar ,

Maybe you can try outputting the filename as a field from you Input tool and then use a filter tool which will feed data to different parts of your workflow.

In your filter tool, you can check if the Filename is File1 for example and if that's true it will feed it to the File1 Logic which is connected to the true output anchor of that filter tool.

The same would happen with the records of File 2.

Hope that helps,

Angelos

atcodedog05

Hi @Akshay_Wadikar

I am curious about logic what exactly is the logic and how is it defined? and how many files do you have?

atcodedog05

Hi @Akshay_Wadikar

You make use of the Alteryx default feature. What Alteryx does is there is an error in a stream in will only stop that specific stream and won't affect other streams. Refer below.

File 1 and File 3 are present hence the stream doesn't have error. And Since file 2 is not present only that stream is stopped.

Hope this helps : )

Hey @atcodedog05 ,

But what happens in case you have 100 xlsx files with the same (or different schema)? It would be troublesome and difficult to maintain to have 100 containers, so you would probably use a wildcard or a batch macro to read all files into a single table. I believe this might be the case here

atcodedog05

Hi @AngelosPachis

@atcodedog05 wrote:
Hi @Akshay_Wadikar
I am curious about logic what exactly is the logic and how is it defined? and how many files do you have?

That's totally a valid point. That's why the above was my first question 😅. It depends on how the logic is varying.

HomesickSurfer

Hi @Akshay_Wadikar

Perhaps consider use of Message and Test tools with expressions to either stop the workflow, stop passing records through the anchor(s), etc...

Works great for me. Same logic can be used to check if output files are available and accessible (not open to user or another process)...

Workflow package attached. Extract to C:\temp to demo.

Input file checker.yxzp

tungduong4920

Hi! @atcodedog05 Can you elaborate on the feature of how you can tell the stream to stop if there is an error? Thank you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703