How to 'select region' to extract rows

[jp_jen]

Hi all! 

Very new to alteryx and was wondering how to do the following. 

I have many sheets within an excel workbook, by factory. I want to just copy the tables and not the summary table below of every sheet. I've seen some questions on copying specific rows (by index) but this is sort of dynamic - every sheet has different number of columns and rows. 

In excel macros, I use select region to copy the table. Any similar function in Alteryx? 

Thanks for your help in advance! 

[markcurry]

If column B is always empty in your summary table, can you filter where that field is not null?

[jp_jen]

Thanks for your reply! Unfortunately, in between the table, some fields do have blanks. 

[markcurry]

OK, if the summary tables is only contained in columns A-D, can you filter out the Null rows from one of the columns from column E onwards.

Another way would be to use the multi-row tool to identify if the data is either the Report or the Summary, I'll attach an example.

[markcurry · Accepted solution]

Hopefully this will do the trick for you...

 

[jp_jen]

Thank you, it works! 

Only thing is that a couple of sheets does not specifically state "Summary" and just pops up the table below. Was wondering if there is any way to split by entire row being null? 

Once again, thank you so much for your help 🙂 

[markcurry]

It gets a bit tricker, (and there might be an easier way) but hopefully this workflow works for you...