How to update Sheet names automatically every quarterly with the help of Alteryx.
Say for example if this quarter RUN sheet names are Jan, Feb and March then next quarter run the sheet names automatically change names to April, May and June and data should get overwritten in that sheet.
Read in the List of Sheet Names from the file using the option it gives you!
But how to update the output data tool with New sheet name than the existing one.
Keep the File Path from the Input Data which will have the sheet name and use it at the bottom of your Output Data tool
User | Count |
---|---|
107 | |
82 | |
69 | |
54 | |
40 |