14 Replies Latest reply: Dec 11, 2012 10:25 AM by Anna Regot Giner RSS

    Load from Web - Google Docs

    Rebecca Molstad

      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);