Dynamic Filter to get the same data in a column

[arjundelara]

Hi All,

Is there a possible way that I can filter out the same data in a column so that if there is additional data it will gather.

[Record ID]

1
1
1
1
1
1
1
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
33
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
68
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
102
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
136
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169
169

The above data is the record I get . all the same data is for the record id data for a single pdf . for example all the record id value 1 is for the data in a single pdf and the other is for another data . I want to just a dynamic filter that gather a single same data to get the data in different pdf data input.

TIA.

[Qiu]

@arjundelara 
it seems that A Unique or Sample Tool is whaty you are looking for.

[JDong]

@arjundelara 

Please refer to the attached flow, unique tool will help here...

You can also filter the null values if you have in your dataset based on the additional filter at the last

[arjundelara]

Hi @JDong  and @Qiu ,

It will gather the one data column only because for example in value 1 all the 1 have a data in other column that what I want to capture.

Thank you.

[arjundelara]

@JDong  and @Qiu 

What I want to filter filter is all the same value in record id but not setting a value in a filter tool to make it dynamic so everytime that there is a new file it will add a new unique number to capture.

[Qiu]

@arjundelara 
Actually not sure I get your point.

The unique or sample requires no input, so it is dynamic.

Can you give us your desired output?

[arjundelara]

Hi @Qiu ,

Attached file is a sample Workflow with static filter to capture a certain data using record id. the data column is a dummy like in a pdf data that has specific record based on the file name. My Desired workflow is to filter a same data to capture all data in [data] column. 

Sorry for consuming your time. I appreciate you thank you.

[Qiu]

@arjundelara 
Dont worry about my time.😁

But again, what is your desired output?

I am sorry but I still dont get your point yet.

[arjundelara]

Hi @Qiu ,

Highly appreciated, My Desired output is to captured all the data in [Data] column based on the same data in [record id] column. Because I have a bulk PDF input files so I want to gather all that files and it will connect to my standard macro so it will repeatedly captured the desired data on my output.

Thank you so much.

[danilang · Accepted solution]

Hi @arjundelara 

What the other posters are asking is "What do you want to do with your data, once it is grouped"  Your answer to this question determines what path you'll take to solve it

The attached workflow show 3 different ways to work with your data, each one using a dynamic  grouping method that will handle changes to your input data, without requiring a filter for each unique id. 

The first uses the grouping functionality inside the Output tool to write your data to different files based on the value in the ID column.  The other two show different ways to amalgamate your data based on the values in the ID field, so that you can generate statistics or otherwise analyze the data. 

Dan