Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Delete top rows based on condition

CGlace
5 - Atom

 

The following table shows the number of products produced by a manufacturing plant on a daily basis.

 

DATEUNITS PRODUCED
01/01/20190
02/01/20190
03/01/20190
04/01/20190
05/01/20190
06/01/20195
07/01/20197
08/01/20194
09/01/20198
10/01/20190
11/01/20190
12/01/20195
13/01/20199

 

UNITS PRODUCED rows 1 -5 contain 0s. This is because plant operations don't commence until 06/01/2019.  0s that occur between 10/01/2019 and 11/01/2019 occurred during operational days but no units were produced.

 

I'd like to delete (or mark as 'null') Rows 1-5 from the table because I'm only concerned about production after the plant has commenced operations.  The condition I'm looking for would find the first row in UNITS PRODUCED with a value greater than '0' and delete (or mark as 'null) all rows prior to this row (i.e. rows 1-5 in the example table). 

 

Do I need to use the Multi-Row Formula tool? 

 

Any help please,

 

Paul

 

 

 

 

 

 

 

1 REPLY 1
OllieClarke
16 - Nebula
16 - Nebula

Hi @CGlace you can indeed do this with a multi-row formula tool. If you set it up like this, then you get what you want:

OllieClarke_0-1573655494643.png

Labels
Top Solution Authors