Summarize results used in the filter tool?

[Rwade]

Hello Everyone, 

Is there maybe anyway we can use the results of the Summarize tool, which provides me with a list of unique names in a column, then in the same workflow I would like to reference that list of unique names to be used as a filter so that I can then separate all rows of data with each unique name?

Please let me know if maybe any questions.

THANK YOU!

[Qiu]

@Rwade 

You can connect the Summary Tool to Filter in an Analytic App.

Is that what you need?

[Rwade]

@Qiu, 

Thank You!  I will first need to go learn about how to use the Analytic App and will report back!

[Emil_Kos]

Hi @Rwade ,

If I understand you correctly you can use the unique tool to achieve this result. Configure it by picking information about the key that should be unique. 

If I miss something obvious please disregard my message 😀

[Rwade]

Hello .@Emil_Kos and @Qiu, 

Thank you both very much for those suggestions. Using the Analytic App that connects the Summarize Tool to a Filter, while it would technically "work"  it is my understanding the user will have to manually select each value for the filter to use and there could be many values which makes it cumbersome to manually select each one.  Using the Unique tool would also technically "work" but it is my understanding this tool only separates a single row of data for each unique value.

Ultimately, I am looking to have all rows associated with each unique value separated into its own set of results.

So if the data set has 25 rows, and there are 5 rows of data for each unique identifier, then I am looking to generate a separate output for all rows associated with each unique identifier. 

[Emil_Kos · Accepted solution]

Hi @Rwade,

The unique tool will not work for you?

Input:

Output:

If that doesn't suit your need can you prepare sample input and sample output? Thanks to that it will be easier to understand what you want to achieve. 

[Rwade]

.@Emil_Kos

Thanks again for taking a look, very much appreciated! 

In my "original dataset / input" example below, we have nine values, but only three are unique values which means we will have three outputs, with each output containing all rows of data.

ORIGINAL DATASET / INPUT:                                         

UNIQUE VALUE	TOTAL
XXX	100
TOM	1200
XXX	300
CANDY	1000
XXX	500
XXX	600
CANDY	700
XXX	800
TOM	900

OUTPUT #1

UNIQUE VALUE	TOTAL
CANDY	1000
CANDY	700

OUTPUT #2

UNIQUE VALUE	TOTAL
TOM	1200
TOM	900

OUTPUT #3

UNIQUE VALUE	TOTAL
XXX	100
XXX	300
XXX	500
XXX	600
XXX	800

[Emil_Kos]

Hi @Rwade,

This workflow will split the output into 3 different sheets. 

When you will split the data what do you want to do with it? You want to use it in the workflow or you want them to have separate output files?

[Rwade]

.@Emil_Kos

I would keep each output in the workflow before exporting back to excel. 

Thank you for the workflow example!  When I run that workflow you sent I only see a single output that still contains all nine values?

[Emil_Kos · Accepted solution]

Hi @Rwade,

i believe they should be splited and you will find them in 3 different sheets.