Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Filtering data into two tables dynamically

Highlighted
7 - Meteor

I've been trying a variety of multi-row formulas but can't quite figure this one out!

 

I've got a set of data that is made up of two tables, but with each new dataset the table can be of a varying number of rows. I've managed to flag where the table ends but now am unsure how to filter the top and bottom half so I'm left with two separate tables. I've been trying to use a multi-row formula to create a new filter column 1 and 0 to then use a filter tool to separate but cannot get the formula to work.

 

Example data (1 is the top tables final row):

 

FlagFilter

null

 
null 
null 
1 
null 

null

 
null 
null 
null 

 

Thanks in advance!

Alteryx
Alteryx

hi @Saj94 ,

 

is this what you are looking to do? then you can filter based on the "new field" column

 

bpatel_0-1575307327512.png

 

hope this helps!

Highlighted
7 - Meteor

Yup that's perfect, and then I can just update the [New Field] for when [Flag] = [New Field] so the bottom line of the table is included in the top half.

 

Thank you!

Labels