Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

caio_caminoski
Contributor

Embedded Labels problem using Web Connector - Google Drive Spreadsheets

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=xxxxxxxx...]

(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

2 Replies
caio_caminoski
Contributor

Re: Embedded Labels problem using Web Connector - Google Drive Spreadsheets

Is it true that the only way to embed labels is if they are in the first row of the online sheet?

sandeep_roy
Contributor

Re: Embedded Labels problem using Web Connector - Google Drive Spreadsheets

Instead of adding skipRows in the URL itself, can you skip the rows by writing for loop in your script.

Community Browser