SOLVED
Combine multiple tables of varying lengths on a single sheet to two outputs for lookups
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
JLMig
5 - Atom
10-31-2023
03:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have a few excel files with multiple tables on a single sheet. The tables can be varying lengths (widths will always be the same) and positioned at varying locations from one file to the next, but they will always be in the same order. I would like to combine them into 2 tables to prepare them for lookups.
Is something like the outputs possible?
Solved! Go to Solution.
Labels:
- Labels:
- Help
- Preparation
- Transformation
7 REPLIES 7
17 - Castor
10-31-2023
05:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hard, but possible.
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
flying008
15 - Aurora
10-31-2023
07:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @JLMig
Yes, it's possible, someone already build the batch-macro for get your want before 2 years, but so complex.
17 - Castor
10-31-2023
09:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
PangHC
12 - Quasar
11-01-2023
12:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
my solution will be to manipulate the headers.
identify tables name, keep 3 columns each, assign columnID and table type, then join with the transposed data.
and finally filter for each table and crosstab back to align the data.
it may complex, but it less tools. 😁
11-01-2023
08:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you! I'm just getting started with Alteryx, so I appreciate all the help I can get.
11-01-2023
08:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!
17 - Castor
11-01-2023
05:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'd appreciate it if you can mark my solution as an accepted solution as well since it splits the tables nicely for you into separate chunks in proper order.
Thanks @JLMig !
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
