Need help with the error message for Google drive input tool

[jocelynteo]

Hello,

I am trying to use Google Drive Input Tool to import a gsheet then write the file to certain location and configure to .xlsx format.

However I keep getting the error for my Google Drive Input: local variable 'no_of_records' referenced before assignment, not sure if anyone knows how to fix the error?

Appreciated that!

[Carolyn]

Did you find anything? I'm getting this error

[MeghanGohil]

I'm also seeing this error.

[Carolyn]

Hi @MeghanGohil , 

I'm running into this on Designer 2024.1, GDrive Tools 1.3.2. I was also previously running into this on 2023.1 / 1.3.1 but it was from different behavior than I'm seeing on 1.3.2. 

What I've found specifically with 1.3.2, that 1.3.1 didn't do, is it gets confused about the file type which can cause this error. For example, if I go into the GDrive Input Tool, select my file, click over to Config File tab, and click back to Select File but then don't wait for it to fully load before clicking onto the Canvas or running my workflow, I'll get that error next time I run the workflow. 

This is what my screenshot looks like to cause the error. I just need to wait and stare at it while it finishes loading, and then I can click elsewhere and run it without an error. 

I've created an Alteryx Support ticket for my specific issue/reproduction steps but they're still investigating.