Excel output file - Re-Arranging of tabs?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have 5 excel input files which I have combined together in a single output file in a different tab. Now, want to re-arrange the tabs the way I want.
For Example: From the output file first tab has to go last, and last tab has to come first.
Is there any way I can do this in Alteryx? Since I am beginner, not sure how to do this. Appreciate help.
- Labels:
- Input
- Output
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
you can use select tool to sort the columns
or you can provide sample data of column names , it can done attaching numerical to the initial data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am sorry bit confused with the answer. I want to sort the Tabs and not the columns. Since I am beginner appreciate explanation, please.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yes tabs can be done
please provide some sample data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@amithkumar070 Are you using a batch macro to combine the files?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for the help. I have attached the output sample data also Input data.
In the output sheet I want see the Index Tab first and BTT tab last & STT Tab middle. This is just an example I have many tabs like this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@amithkumar070 give this macro a try! 😀
The IF statement in the formula tool is driving the order. Customise that part as you see fit:
All the best,
BS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@amithkumar070 Another way of doing this
