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
Solved! Go to 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
Super Cool!