Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Include Data Only after a row containing a specific word

Highlighted
6 - Meteoroid

Hi there,

 

I have a excel file that contains data formatted like this:

NameJanFebMarchApril MayJune
Cat1234  
Dog 34   
Fish13    
Include2874  
Cat563   
Dog 74   
Exclude514144  
       

 

How do I only include the rows starting and ending at Include?  (Bolded)

 

Thank you!

Highlighted
Alteryx
Alteryx

I like to use a formula tool to make a flag on the row where name contains the value, then use a running total on the flag column, and then a filter where you can say only include the rows where the running total is zero. Workflow is attached!

 

flag.png

Highlighted
Alteryx
Alteryx

I would use a multi row formula instead of a formula if you also need to include the row that says include. See workflow attached. 

Highlighted
6 - Meteoroid

Thank you, that worked!

Labels