Split tables from One Excel File

[wendyzjy]

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.

[aatalai]

@wendyzjy look at updating the input range

[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?

[binuacs]

@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?

[aatalai]

@wendyzjy  agree with @binuacs is there an idenitieifer? If so this should work

[wendyzjy]

1. processing details table has way more cloumns

2. two Blank rows can tell

3. there is "summary details:" and "processing details:" on the above of two table respectivly

[dwstada]

here is a workflow that should help you :)

[binuacs · Accepted solution]

@wendyzjy one way of doing this

[wendyzjy]

It suits my use case and easy to modify. Thank you!