Automatically filter new rows

Question

Is there a way to automatically filter a new row?

So lets say I have 26 rows:

Segment:

A

B

C

D

E

F etc...

instead of creating a new filter each time so that it looks like below for each segment, and therefore I dont have 26 different filters, is there anyway for it to automatically split the data based on row value?

Automatic Filter.png

CoG · Answer

Depending on why you are splitting the data, it is possible that you would have needed to split the data in the first place. Some Tools like the Multi-Row Formula Tool have built in Grouping features that allow you to effectively "split" your data and run a single process for each segment (in this case). How many Tools are you using after the filter? Are you doing the same process for each segment or does the process change?

Also, when you say "new" row, what does that mean? Is there a field that would indicate what values are new and which are old? That may also help simplify things.

Qiu · Answer

@kpontarollo

If you have similar operation for each row after the filtering, maybe we can use a Batch Macro with the value of each row as Control Parameter?