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
15 - Aurora
15 - Aurora

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