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.
Since all sheets have the same field names, you need to repeat the load script for every sheet. The result will be one large table. You can also use the for...next function to run the load as many times as you wish without repeating it, but in this case you must pass the sheet name as a parameter.
Tables @1, @2, and @3 are the only options I can see. I am very new with LOAD script, so I apologize if this is a very dumb question, but do you know how to identify the tables? I know how in Excel, but Google Docs spreadhseets seem to have far less functionality (I never use them).