community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Using Summary results as criteria in a later Filter or Formula

Meteoroid

Hi

 

Is it possible to use the result of a Summary as the criteria in a later part of the workflow?

 

For example I have a Summary which give me the count of ID Codes from my data. So more than 1 ID code

 

I want to then use these ID Codes in a filter, to split other data into two groups, one that has ANY of the ID Codes in a specific column, and then the ones that dont.

 

It might not be possible , im not sure.

 

I suppose I could write the Summary output to a file, then read that file in and it could then be specified as a critera in a formula, but I wondered if there's a more direct way,

 

Hope i've explained that well enough.

 

Any help would be greatly appreciated.

 

Thanks


Ste

Highlighted
Meteoroid

Its just a join!

 

Join the Summary to my Data, on the column, and the Matching results will only be the ones that contain the entries in the Summary count.

 

So, er....nvm!

 

 

Labels