How to filter data based on the categories in the actual input?

[yoyoumysin]

How can I set up a filter that separate the flows based on the categories from the actual input?  For instance, in the attached Excel, the Industry Classifications could be a slightly different set of categories.  Every time when I read the data file, I want to check the available categories under "Industry Classifications" and for each of such category, I want to calculate the weight average of DSO weighted by REV.  I do not want do a manual exhaustive filter by all possible category.  Thanks!

[ArtApa]

Hi @yoyoumysin - Here is what you can try:

[yoyoumysin]

Thanks, this looks promising.  Any chance I can be able to join them together so the user doesn't have to manually run the second step?

[grazitti_sapna]

@yoyoumysin, the example shared by @ArtApa  can be modified in such a way that you need not run it manually but instead use a chained app workflow.

Step 1: Select a file using the file browser.

Instead of running the workflow manually now, it runs as per the user's input although it will do the same thing technically but now the workflows are linked.

Step 2: Select the values from the list.

Step 3: The output.

There is no other way to combine this all in a single workflow as your Industry classification will be dynamic and the values may change so in order to overwrite the old values with the new ones you will have to refresh the workflow and the chained app is seems to work in your use case

Thanks!

[ArtApa]

Hi @yoyoumysin - You don't have to run them manually. They are chained. You just need to run FilterAA 00.yxwz, as shown below:

Then the first app will call the second:

[ArtApa]

@yoyoumysin - You may learn more about how to chain apps here: https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120