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.

Outputting 5 different sheets to one excel workbook

brian_mcdonough
6 - Meteoroid

I'm using a formula tool to create the file path for 5 different sheet names, but using the same naming convention for the excel workbook. I'm getting the error that it's "unable to create backup of..." which is causing only 2 of the 5 sheets to output on to the workbook. How do I configure the workflow so that the .bak file doesn't output and it allows for all 5 sheets to be posted to the workbook?

 

 

2 REPLIES 2
geraldo
13 - Pulsar

@brian_mcdonough 

 


It would be interesting if you put a print or the workflow to analyze.
Your message is strange.

nagakavyasri
12 - Quasar

@brian_mcdonough Try this workflow

 

Screenshot 2023-05-11 141126.png

Labels
Top Solution Authors