Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
true
very annoying...
not supported I guess, sorry I cannot help you further.
No worries. Thank you anyways! Maybe someone else on the Community has encountered this before?
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.
Got it. Thanks!!
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