Split Data into tabs in excel workbook by Date

JACKIEC1992

Good morning,

I have a large data set initially broken down by State tabs. I combined the data set into Alteryx because instead of the data being broken down in tabs by state. I'd like it to be by "Pay Date". 

My goal is to create a new Excel workbook that has tabs listed by PAYDATE, not State.

Please assist. I've attached a screenshot of the workflow of combining the original tabs. 

Screenshot 2023-10-26 102820.png

ERC_2020 PR Data_By Pay Pd.xlsx

Prometheus

@JACKIEC1992 You can use these macros in this package. One takes the full path and each sheet name from a file and creates a full path including the sheet name. The other opens the file down to the sheet name and unions the data. Then in your Output Data tool, select "Take File/Table Name From Field", select Change File/Table Name from the dropdown menu and then select PayDate from "Field Containing File Name or Part of File Name." Then check or uncheck "Keep Field in Output."

Create Sheets.yxzp