Initiating different input based on a condition

rdeshpande

Hello,

I am trying to initiate a different Input based on the day of the week.

If it is Monday, it should run input 1 (SAP variant for data from Fri-Sun)

If it is Tue-Fri, it should run Input 2 ( SAP variant for data from the previous day)

After this step, the rest of the workflow is exactly the same. Is there a way to accomplish it?

Thank you

Input

Accepted answers

atcodedog05

Hi @rdeshpande

Here is how you can do it. You can read both files and filter data accordingly. If Monday Input1 data will go forward and input2 will be blank if its not Monday Input2 data will go forward and input1 will be blank. This way you can regulate which data is fed into the later workflow.

Workflow:

Hope this helps : )

mondays run.yxmd

All comments

atcodedog05

Hi @rdeshpande

Workflow:

Hope this helps : )

mondays run.yxmd

csmith11

Hello,

I wanted to provide another option that does exactly what you requested as this may prove helpful in the future.

This will prevent the other input files from being loaded. This also would allow you to run the workflow in the instance that the Friday input does not exist yet.

You can use a Condition Tool in combination with action tools to disable containers when specific inputs are not required.

You can use the test view in the Interface Designer window to confirm how the workflow will behave when run. Click Open Debug.

When ran on Friday, the Monday input is disabled.

Its important to note that the action tools will not modify the contains except when the workflow is run as an App or on Alteryx server.

See Workflow App attached. After Downloading, right click the file and click Edit to view workflow.

ConditionalInputs.yxzp

JohnsonRaju

Hi,

I tried using the same sequence of tools (Condition followed by an action to disable/enable the container).

But I encounter the below error. Could you please help understand why?

Thanks!

Edit : The action tool configuration is as below

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703