topic Re: Excel output file - Re-Arranging of tabs? in Alteryx Designer Desktop Discussions

Excel output file - Re-Arranging of tabs?

amithkumar070 — Mon, 24 Jul 2023 11:00:53 GMT

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.

Re: Excel output file - Re-Arranging of tabs?

BRRLL99 — Mon, 24 Jul 2023 11:07:20 GMT

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

Re: Excel output file - Re-Arranging of tabs?

amithkumar070 — Mon, 24 Jul 2023 11:21:34 GMT

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.

Re: Excel output file - Re-Arranging of tabs?

BRRLL99 — Mon, 24 Jul 2023 11:27:07 GMT

yes tabs can be done
please provide some sample data

Re: Excel output file - Re-Arranging of tabs?

binu_acs — Mon, 24 Jul 2023 11:40:47 GMT

@amithkumar070 Are you using a batch macro to combine the files?

Re: Excel output file - Re-Arranging of tabs?

amithkumar070 — Mon, 24 Jul 2023 12:33:19 GMT

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.

Re: Excel output file - Re-Arranging of tabs?

BS_THE_ANALYST — Mon, 24 Jul 2023 12:21:14 GMT

@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,

Re: Excel output file - Re-Arranging of tabs?

binu_acs — Mon, 24 Jul 2023 13:00:24 GMT

@amithkumar070 Another way of doing this