How to delete all succeeding rows after a specific row in Alteryx

Question

Good-day! Would just like to know if there is a way to delete all the rows after a specific row in Alteryx. In what I am currently working on, I want to remove all the rows after the row with subtotal Row# 492 (Row#493 onwards to be removed). The row with the subtotal may also change for instance it may be in Row #310 next time I run the workflow, hence I would need to remove Rows 311 onwards. Thank-you very much!

Junnel_8533 · Accepted Answer

Hi @DavidSta ,

Thank-you very much for your response, I am relatively new to Alteryx, and would just like to understand who you came up with this expression below. Thank-you very much!

sparksun · Accepted Answer

If all the rows after the Subtotal row only have Null value,then you can just use Data Cleansing tool.

DavidSta · Accepted Answer

Hi @Junnel_8533,

there is not much more to explain on the logic from the formula than from my initial post.

If you want to generally understand the Multi-Row Tool and how it work I can recommend to check out this Interactive Lesson.

The recommendation from @sparksun is great as well if it's about "keeping all rows instead of the null ones".