community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Revise the Google Sheets Drop Sheet tool

The behavior of an "Overwrite Sheet (Drop)" configuration is such that it breaks formulas (#REF) that point to the overwritten sheet and named ranges that reference the overwritten sheet.  This is a bummer because the only way I've found to overcome the issue is to write a script that re-applies the named range.  This works, but it greatly raises the barrier to using this tool and in some corporate environments it won't even be possible.

 

What would probably be a good alternative behavior is to delete the contents of the sheet, rather than the rows/columns/cells of the sheet.  I think both probably have valid use cases but my proposed functionality is going to cause fewer issues and be the more popular behavior for most users.  I believe there is a google sheets API call for just this kind of behavior...

4 Comments
Asteroid

Hi,

 

I have been having the same issue for awhile now. I want the data on the sheet to be replaced but without deleting the sheet. One way I did solve this issue is using an indirect formula. Create a new sheet (Datasheet or name it whatever you want) and only place the following code in row 1:

 

=INDIRECT("'Output Alteryx'!A:A")

 

Use the double quotes only when there is no space in the sheet name. If there is a space (as in the example) use single quotes for the name.

Do this for every column (B:B - C:C) etc. and that way you can reference your new sheet which will be an exact copy of your output. Its a small workaround but currently works great for me.

 

 

Meteoroid

Thanks DanielH.  Indirect works!  Kinda Janky but least-janky solution I've found so far.  I still think that formatting should be retained as part of the default functionality of the tool. 

Alteryx
Alteryx
Status changed to: Under Review

Hi All,

 

Thanks for the feedback- please continue to upvote if you're interested in this functionality!

 

Best,

Alex

Meteor

@DanielH - thank you for this solution!  It's the least complex of anything I can try right now to get my stakeholder what they need.  Appreciate it!