Multiple Sort

Question

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 Answer

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 Answer

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 Answer

Thank you, was able to fix it