Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

dynamic configuration of multiple Filter Tools from single file

Nicholas_White
8 - Asteroid

Hi,

 

I'm not sure how to phrase what I want to accomplish correctly using words, so I'll use a drawing instead.

 

This is mockup drawn in Visio of what I want to accomplish: 

 

vitaminman12_0-1661374701283.png

  • 1. A data file of thousands of records my team puts together for me each month.
  • 2. A list of data points and the respective Filter Tool configurations needed to arrive at each data point.
  • 3&5. A Select Tool which isolates the Filter values needed for a Filter Tool. This will drive an Action Tool.
  • 4&6. A Filter Tool. It gets its parameter names and values from the connected Action Tool. 
  • 7. The output file which has all the resulting data points.
  • The green line is my fancy way of indicating 'loop until done'.

 

I envision an App where the user uploads the 1. data file, and 2. data points + filter configuration file, hits Run, and the App cycles through both files until there are no more data points to create. Also, the App will have possibly dozens of Filter Tools.

 

Is this kind of pipe-dream possible?

 

Thanks

 

Nick

3 REPLIES 3
joelmiller66
9 - Comet

@Nicholas_White  It sounds like you need an Iterative Macro to accomplish the looping logic.

 

For the Filter Tool I would look at using the INCLUDE clause to create a list of items you are filtering for. The expression can be updated from the Action Tool.

joelmiller66_0-1661375909568.png

 

 

You can also use a Dynamic Select Tool to select the fields you need with an INCLUDE clause again. Using the Via Formula option.

joelmiller66_1-1661376034047.png

 

 

Nicholas_White
8 - Asteroid

Hi @joelmiller66 ,

 

I sat on your reply for a few days to think about it.

 

I finally got the Action Tool to work...not exactly how you proposed above, but your screenshots sent me down a path I wouldn't have even known to go down otherwise.

 

 

For the benefit of others:

 

1. I pre-made the entire formula with some other tools.

 

vitaminman12_8-1661789804050.png

 

2. I pass that formula into Bach Macro which represents an updateable filter:

 

vitaminman12_4-1661789330331.png

 

 

3. The Action Tool is set to 'Update Value with Formula', it's going to replace the variable [RECORD_ID] which it will look for in the Filter Tool.

 

vitaminman12_7-1661789622151.png

 

 

4. Inside the Filter Tool, I put in the variable [RECORD_ID] (one of the available fields coming in from the data input), this is the field which eventually gets replaced by the entire formula.

 

vitaminman12_5-1661789374283.png

 

I tried swapping out individual components of the formula, but I always managed to find new and frustrating ways to break it. Passing the entire formula seems to be the most reliable way to overcome this right now.

 

Thank you,

 

Nick

joelmiller66
9 - Comet

@Nicholas_White great work!

Labels
Top Solution Authors