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
