Dynamic Input With Condition

Hi,

I have been working on a workflow that has 5 inputs. The first 4 inputs are standard inputs and will be used in all scenarios but the last input cannot be used in some cases. I want this input to run on a condition.

Condition: I have also used a Count Records tool to form the condition, that is, if the value in Count Records tool is 5 then only run the 5th input file else run the first 4 inputs only.

Now, I'm stuck on how do I connect this condition with the (dynamic) input.

Common Use Cases

Dynamic Processing

Preparation

Accepted answers

jrgo

@sanketkatoch05

Here's a packaged workflow that contains the workflow, batch macro and one of the "week" files.

I stripped out everything from your original workflow except for the part that reads in the Week 5 data and replaced the Dynamic Input tool with the macro. Image below describes how to set up the connections.

The Macro itself is pretty simple. The Action tool could have been configured to have a hardcoded "5" in the formula, but figured it may be better to add a Text Box to allow you to specify what value it should look for so that this could be used for other use cases.

When the condition is met, the Action tool updates the Detour tool to go Left, which enables the Dynamic Input tool. When it's not, data goes to the Right which samples 0 records and creates the arbitrary "_Condition_Not_Met_" field.

Hope this helps!

Jimmy
Teknion Data Solutions

Dynamic Input with Formula_JGO.yxzp

All comments

jrgo

Hi @sanketkatoch05

I believe you'll have to create a batch macro. the value from your Count Records tool would feed into your control parameter. there's probably various ways to use the value from the CP, but best way - IMO - is to have it update a Detour tool.

Using a filter tool won't work because the Dynamic Input tool will still run. A Detour tool, however, completely disables tools that the data stream is detoured away from.

sanketkatoch05

Hi @jrgo,

I'm pretty much new to Alteryx. I'm not sure how to make a Batch Macro on a dynamic input file and likewise, I don't know how the Detour Tool works.

Since the files that I'm working on are very confidential, so should I send a dummy workflow, so that I can get a better understanding?

DylanDowrick

I went with two batch macros. The first didn't pass the empty file through the first time, but it's a good check in case it ever does.

The Workflow:

The directory is linked to a folder with those five files.

The first Batch Macro:

This essentially outputs a single record of FullFilePath and CountRecords. The Macro outputs a union of all five files in the original workflow.

The second Batch Macro:

As straight forward as that gets where only files with record counts >0 are fed into it!

sanketkatoch05

Hey, @DylanDowrick.

Thank you for replying, can you send me the workflow so that I can test it with more data?

Also, will this macro work with a Dynamic Input tool?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703