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

Alteryx designer Discussions

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

Google Sheets Output writing a blank sheet

Meteor

Hi Probley - thank you for your follow-up!  Contrary to what I posted yesterday, it isn't the number of columns, but what was in the headers of those last columns that were causing my issue. Apologies for the mislead. 

 

I did some further research and have found the following:

 

1.  The field names for those last columns contained the word "Total" followed by lengthy text that included parentheses and ampersands.  

 

2.  Once I changed my field names to something simpler and removed special characters, the issue disappeared.

 

I do need to do some additional testing today (is it the word "Total" or the length of the text or the special characters) but my issue disappeared when I simplified my field names. 

 

Interested to hear any similar experiences from the Community.

 

 

Highlighted
Asteroid

@Sbinkley - Ampersands was the problem for me and it works just fine now. Thank you!

Meteor

Hello - my additional tests have verified that ampersands in any of the Google output titles result in a blank record begin output. 

 

 

Meteor

Yes, I found the same. Removing one ampersand in a single column title resolved the blank sheet issue immediately. Limiting number of columns, or long column titles did not seem to have an effect. 

Meteor

Yes, limiting columns was not the issue.  I've been able to output as many columns as needed after removing the ampersands that caused the problem. 

Labels