Filtering rows with specific conditions

Question

I have an example of an input file attached

I want to be able to pick up each time only what is filtered

This is the G55200 unit on Level 2 and all the Levels below it until

the next level 2 item which in this case is G55100

How do I do this with alteryx

UNIT

LEVEL

DESC

IS BASE

CUR

G55200

2

AAA

FALSE

AUD

B12345

3

B

TRUE

AUD

B23456

4

C

TRUE

AUD

alteryx example.xlsx

ncrlelia · Answer

Hi @DC21,

You can use a Multi-Row formula to indicate which rows to keep.

Hope this helps.

Cheers,

Lelia

binay2448 · Answer

Hope this will answer your question..

Filtering rows with specific conditions.yxmd

Laurap1228 · Answer

I am not sure what your filter criteria are, but typically in Alteryx, you use the filter tool: