Analytic app should run based on date filter

Question

Hi guys,

I have an analytic app in which the user enters a budget file and then the workflow should check whether the file is entered on a date which is less than a specific date. If date<specific date then the app should run another analytic app else it should ask the user some questions regarding why the file was uploaded late.

Also I want to make dynamic selections based on the output of the filter tool but all the app selections are coming on the same app page.

How do we achieve this in alteryx dynamically?

Budget App community.yxwz

Carlithian · Answer

@hansfinesse

We can make it work with some shannangans.

For ease, the starting process is A, and the two potential follows ups are B and C. A is configured to have a chained app, this is blank and will be reffered to as Z, and on this given run the correct follow up is C.

Idea One

Use command line to rename the files, so C is renamed to Z and Z is given a dud name. So when Z is called it is actully the C file.

You would need to include logic in C and B to reset the names, this could be messy

Idea Two

Use two input tools in workflow A to bring in the XML of B and C. During the run overwrite the XML of Z with C. This way when Z is called it has the functionality of C

Hope this helps

hansfinesse · Answer

@Carlithian Can a single app chain to multiple apps? I can only see one workflow chained to another app in the interface designer.

Carlithian · Answer

This is quite a complex process, so I'm attaching some links that will explain the chaining process better than I can here.

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120#done

https://www.thedataschool.co.uk/brian-scally/chaining-apps-in-alteryx/

Since this is a new process for you I recommend taking it in steps.

1. Have a workflow that pull in the input file, this should chain to a second workflow that allows the user to select an entity from the data in this file

2. Have that same initial workflow chain to a second workflow that asks for the reason

3. build the logic to switch between the two options for the secondary workflow

I hope this helps, if you can get chaining apps down you unlock so much with Alteryx