Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Convert excel data to multiple tabs based on 2 columns

Highlighted
7 - Meteor

See below snapshot of my excel table. The Co column has several company numbers listed, with various states attached to each company code. Within a single workflow, is it possible to convert the Co (company code) column into separate excel files, then, within each new excel file have the respective states detail move to its own separate tab. 

 

clipboard_image_0.png

Highlighted
12 - Quasar

Hi @bradaba ,

A batch macro  can  split this data  into  multiple  excel files with  multiple state tabs .

If you are looking for a working example  please attach  sample  data  for  2 company codes . 

Highlighted
7 - Meteor

Thank you @benakesh. See sample data attached. 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @bradaba you can achieve this with an formula tool and the output tool. You create a filepath in the formula then configure the output tool to replace with a field and select overwrite sheet in the output options.Output.png

Highlighted
12 - Quasar

Hi  @bradaba ,

@JosephSerpis  has  the  simplest and best  solution . 

Highlighted
7 - Meteor

Thank you! @JS420 One more question, is it possible to have the original "example.xlsx" tab as the first tab within each of the new output files? 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @bradaba it is possible and have mocked a workflow that produces a source tab which is the original data.

Labels