How to create a mapping table to output data into corresponding excel sheets

[jms2510]

My dataset looks similar to the one below. I am able to export to Excel based on the service line, but I want it so any service line that includes 'Accounting' goes into a sheet called 'Accounting', instead of a new sheet being created for each service line.

I realize that I likely require a mapping table for this. I've created a basic one, but I could use assistance in establishing a connection between the mapping table and Alteryx, enabling it to read and utilize the table effectively.

Ultimately, I want the Output to be 5 sheets

-Accounting (Accounts payable, accounts receivable, audit, tax, financial reporting employees)

-Finance

-Human Resource

-IT

-Payroll

[Prometheus]

@jms2510 You can create the sheet names as a column then configure the Output Data tool to send data to a specific sheet based on these sheet names. 

 

 

 

[binuacs]

@jms2510 Another method with mapping file