Start Free Trial

Alteryx Designer Desktop Discussions

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

Automatically filter new rows

kpontarollo
8 - Asteroid

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? 

 

 

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@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?

CoG
14 - Magnetar

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.

Labels
Top Solution Authors