Alteryx Designer Desktop Discussions

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

Google Sheet Input Tool - Data Range

AlisonK39
7 - Meteor

Hi! 

 

I am trying to use the Google Sheet Input tool - but my data does not start on row 1 (it's on row 4).  I've tried using the Select Records tool after the input - but when I put in "4+" I get an error - Tool #50: No Valid Fields were selected".  

 

I can't delete the first three rows of the Google Sheet - I'm not the owner and I don't want to copy the data to a new sheet since the data is live.  

 

Any 

2 REPLIES 2
DawnDuong
13 - Pulsar
13 - Pulsar

Hi @AlisonK39 

i assume that when you read the full file there is no such errors (if you still get the errors the it is the input issue, not because of skipping the rows).

 

You can try sample tool set to “skip first N rows”

https://help.alteryx.com/current/designer/sample-tool

dawn 

 

AlisonK39
7 - Meteor

This worked - thanks for your help! 

Labels