Designer Data Extraction|Locate and extract table from Excel

[Mj9715]

Hi All, there are have been many general suggestion on how to extract data from a cluttered excel input sheet. However, none of them fit to my case.

I have three tables highlighted in orange which I need to extract separately from attached sheet. both input and extracted output in attached excel. 

Can someone suggest the best way to do this?

[atcodedog05]

Hi @Mj9715 

Are the data position is fixed?

[atcodedog05 · Accepted solution]

Hi @Mj9715 

If the position is fixed you can extract like below.

Workflow:

Hope this helps : )

[Mj9715]

Thanks @atcodedog05 ! I wouldn't say it would be fixed - but this an be tweaked to change the select tool fields in case it shifts around.