Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to everyone,
I would like to connect to a web file, but unfortunately, it seems I'm making a mistake during the connection. This is my code:
LOAD * FROM [lib://data]
(url is [https://raw.githubusercontent.com/civio/covid-vaccination-spain/main/data.csv], html, utf8, embedded labels, table is @1);
Thank you in advance.
Daniel
Hello @Dlopeze
when i create a connection to webfile, with the URL specified in the text above
Then you can get the data e.g. like this:
Load * From [lib://csv1]
(txt, utf8, embedded labels, delimiter is ',', msq);
or if you want not to load all but only specific elements
LOAD
informe,
"comunidad autónoma",
"dosis Pfizer",
"dosis Moderna",
"dosis AstraZeneca",
"dosis Janssen",
"dosis entregadas",
"dosis administradas",
"% sobre entregadas",
"personas con al menos una dosis",
"personas con pauta completa",
"personas con dosis adicionales",
"última vacuna registrada"
FROM [lib://csv1]
(txt, utf8, embedded labels, delimiter is ',', msq);
just delete the lines which you don't want. For the moment both queries will retrieve 4663 lines with your web file.
best regards
Sebastian
Thank you for your reply Sebastian,
Unfortunately, the button about "select a web file" is not avaliable now in Qlik cloud. I found another way to get data using google Drive connector:
https://www.vizmind.eu/connecting-to-web-files-in-saas-editions-of-qlik-sense/
Best regards,
Daniel
Hello @Dlopeze
when i create a connection to webfile, with the URL specified in the text above
Then you can get the data e.g. like this:
Load * From [lib://csv1]
(txt, utf8, embedded labels, delimiter is ',', msq);
or if you want not to load all but only specific elements
LOAD
informe,
"comunidad autónoma",
"dosis Pfizer",
"dosis Moderna",
"dosis AstraZeneca",
"dosis Janssen",
"dosis entregadas",
"dosis administradas",
"% sobre entregadas",
"personas con al menos una dosis",
"personas con pauta completa",
"personas con dosis adicionales",
"última vacuna registrada"
FROM [lib://csv1]
(txt, utf8, embedded labels, delimiter is ',', msq);
just delete the lines which you don't want. For the moment both queries will retrieve 4663 lines with your web file.
best regards
Sebastian
Thank you for your reply Sebastian,
Unfortunately, the button about "select a web file" is not avaliable now in Qlik cloud. I found another way to get data using google Drive connector:
https://www.vizmind.eu/connecting-to-web-files-in-saas-editions-of-qlik-sense/
Best regards,
Daniel
this post really needs a reply from Qlik ----
what are the possible ways to do a webfile / web file connection in SAAS/ Qik Cloud Government?
What are the current workarounds in SAAS/QCG for this GAP in product functionality?
This needs some good documentation, with some common real world examples.
when will webfile be added to SAAS/QCG?