Split tables from One Excel File

hi,

I have below two kinds of table data in one Excel, the Summary Details table is the one I don't need, and the rows length is not fixed, how to use Alteryx to make data cleansing to keep only the "Processing details" table? There are blanks between the two tables.

Screenshot 2024-04-10 154411.png

Book2.xlsx

Datasets

Accepted answers

binu_acs

@wendyzjy one way of doing this

Processing_10042024.yxmd

All comments

aatalai

@wendyzjy look at updating the input range

input range.PNG

Split tables from One Excel File.yxzp

wendyzjy

thank you, but this is just am example, the fact could be hundreds of rows and it is not fixed, any other ways to split tables not by selecting range?

binu_acs

@wendyzjy is there any label or name present in your excel to identify these two tables? I mean how you identify which table is summary details and which one is processing details?