2 Replies Latest reply: Oct 26, 2017 4:53 AM by Sandeep Roy RSS

    Embedded Labels problem using Web Connector - Google Drive Spreadsheets

    Caio Engelhardt Caminoski

      Hello Community,

       

      I have been facing an issue. I am loading data from an online spreadsheet I have, however I can not get Qlik Sense to identify the labels.

       

      I am using the QlikWebConnectors 2.2.0 which is generating a URL qvx like the following:

       

      LOAD

          Column1,

          Column2,

          ...

      FROM

      [http://localhost:5555/data?connectorID=GoogleDriveConnector&table=GetWorksheet&worksheetKey=xxxxxxxxxx&skipRows=6&appID=]

      (qvx);


      As you can see there is a skipRows parameter equal to 6 in the URL as my data do not start from the first row in the sheet. I tried using the wizard from qlikview and qlik sense and in neither i could embed the labels.

       

      I cannot do the alias manually as the user could be able to insert a new column and mess up all the names.

       

      Any ideas?

       

      Thanks in advance,

       

      Caio