SOLVED
Designer Data Extraction|Locate and extract table from Excel
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Mj9715
8 - Asteroid
‎10-27-2021
04:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
- Preparation
3 REPLIES 3
22 - Nova
‎10-27-2021
04:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
22 - Nova
‎10-27-2021
04:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎10-27-2021
05:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
