Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Adding a new sheet to Google Sheet every time the App is running

panupong
6 - Meteoroid

Hi,

 

I've created an Alreyx app and the output is in Google sheet format.

I use Google Sheets Output tool. I select Add sheet to the existing spreadsheet and I have to specify the name of the new sheet e.g. Sheet1.

 

My issue is this app will be run on Alteryx server multiple times with different parameters. 

For the first time it won't have any issue and sheet1 appears just fine but

the second time it will get an error message since Sheet1's already existed.

 

I would like data for each run to appear in different sheets (tabs).

Is there any way that the user can just manually define the name of the new sheet?

or 

Is there any way that every time the app is run, it will automatically add a new sheet to the spreadsheet?

 

Please advise.

 

Thank you.

 

 

3 REPLIES 3
panupong
6 - Meteoroid

I figured out how to add new tabs with different names.

Using a combination of Action tool and Interface.

 

Thank you.

abartoszek
7 - Meteor

I am facing the same issue, do you perhaps have a macro or workflow you could share?  Thanks!

cburton
5 - Atom

Could you attach an example of how you utilized the action tool and one of the interface tools? I'm thinking I'm not using the correct interface tool since mine is failing.

Labels