sorting Ecel tabs in Alteryx designer

[StephenT]

Hi all,

Is there a way in Alteryx designer to sort Excel tabs ? I have an EXcel workbook that will by End of Year contain upto to 50-odd tabs and am looking for a way to have nee tabs (created weekly) appear at he far left-of the tabs already created (per screen shot below)

[gautiergodard]

@StephenTOne way to easily do this is by pre-pending a number to each one of your tab names.

i.e "1. LoA-2022-11-09" 

You can do this dynamically in the workflow to ensure the left-most tab is always labeled with a "1"

[StephenT]

thansk @gautiergodard 
So the "1." at the front of the tab name will automatically insert it at the far left ?

[gautiergodard]

@StephenT Correct, Alteryx will output the tab sequentially based on the number. 

Kindly accept this solution if it provided a solution to your question.

[gautiergodard]

@StephenT did this work? If so please accept this solution to make it easier for others to find an answer ! 

[StephenT]

Hoi @gautiergodard 
I ran a live data run today, and unfortunately the tabs prefixed with a number are being added to the very far-right, not the far left as desired.