SOLVED
Compilation of sheets with specific Details
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
RekhaS
7 - Meteor
‎07-17-2023
05:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Folks,
i have a requirement where in i need to combine the data for few sheets to create a .hyper file for my tableau report. Sample sheet is attached. I need to combine the data for tab A-F only with all the headers and metrics given in each sheets including the sheet name in the same tabular format where the years will be in columns and metrics will be rows. Please advise if anyone has optimised solution for the same
Solved! Go to Solution.
Labels:
- Labels:
- Tableau
3 REPLIES 3
binuacs
21 - Polaris
‎07-17-2023
05:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@RekhaS One way of doing this with the batch macro
‎07-17-2023
06:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Date format got changed in the output , can you specify the reason. Though solution looks like it will work. Thanks
binuacs
21 - Polaris
‎07-17-2023
06:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@RekhaS Updated the workflow to reflect the correct date format
![](/skins/images/D34B41DA407DC996E7BFF253AD24F7E2/responsive_peak/images/icon_anonymous_message.png)