Multiple Sort

[KANNAM2]

Hi there,

I am new to Alteryx creating a workflow. I am stuck at a point where I need to sort the column Access Type (Add, Remove, remove all), each record's result should be exported in different tabs. In excel, I would simply sort the column and copy and paste each unique Access types in new spreadsheet embedded with tabs for each.

[JosephSerpis · Accepted solution]

Hi @KANNAM2 there are many ways to do this. The attached workflow shows you three ways to separate your data into different tabs and excels.  

[estherb47 · Accepted solution]

Hi @KANNAM2 

You can do all of that with the Output Data tool in Alteryx. 

Give the new Excel file a name, and a default sheet name. Then, towards the bottom of the configuration window, tick off Take File/Table Name from Field.

Choose "Access Type", and choose to change the File/Table name. This should get you what you want. Be sure, in the options, to choose Overwrite Sheet, so that you're able to run your workflow more than once and have successful output.

Let me know if that helps.

Cheers!

Esther

[KANNAM2 · Accepted solution]

Thank you, was able to fix it