Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load from Web - Google Docs

I am trying to load data from a file on Google Docs, but the document has multiple sheets and only the data from the first sheet is being captured. Does anyone know how I can edit my script to include data from all the sheets? All the sheets have the same data fields, they just need to be joined into one big data set.

My current script looks like this:

LOAD

F2 as EmployeeName,

    
F3 as StartDate,

    
F4 as EndDate,

    
F5 as Duration,

    
F6 as Category


FROM

[https://docs.google.com/spreadsheet/etc...]

(
html, codepage is 1252, embedded labels, table is @3);

14 Replies
giakoum
Partner - Master II
Partner - Master II

true

very annoying...

not supported I guess, sorry I cannot help you further.

Not applicable
Author

No worries. Thank you anyways! Maybe someone else on the Community has encountered this before?

swuehl
MVP
MVP

I was able to access the different sheets by first publishing the document (via Google Docs publish feature), then use the published doc URL and used the gid=0 / gid=1 to switch between sheets.

This will somewhat create a public access to your document, only secured by the encrypted URL.

Not applicable
Author

Got it. Thanks!!

Not applicable
Author

Hi!

has anyone found a solution for this problem?

I can not load either the sample document of numbers and letters, I can only load the numbers gid...

Thanks in advance