Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Alteryx sheet creation

Chaitra_04
6 - Meteoroid

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.

3 REPLIES 3
alexnajm
18 - Pollux
18 - Pollux

Read in the List of Sheet Names from the file using the option it gives you!

Alteryx sheet creation.png

Chaitra_04
6 - Meteoroid

But how to update the output data tool with New sheet name than the existing one.

alexnajm
18 - Pollux
18 - Pollux

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

Alteryx sheet creation 2.png

Labels
Top Solution Authors