How to remove the below rows start with first NULL row

[DataKiller]

Hello everyone,

   I am trying to when the first row with NULL, then I remove all below rows. 

exp. row 1803 have null, so I keep the data till to row 1802, and delete all rows below 1802 row

[RolandSchubert · Accepted solution]

Hi @DataKiller ,

I would add a RecordId, identify the first row with NULL values, append the RecordId of this row to all records and use a Filter tool to remove records. I've attached a sample workflow.

Let me konw if it works for you.

Best,

Roland

[JFAU]

Super Cool!

[YaGurlKate]

I realize this is pretty old but I came up with something simpler today that also works.