Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

dilema2468
New Contributor

Loading table from a website which is not in HTML format

Hi folks,
I am trying to load a table given by Bureau of Labor Statistics Data

But this page is not in HTML format.

Can anyone help me out loading this page in QlikView and fetching the below table?


. qlikProblem.png

6 Replies
sergio0592
Valued Contributor II

Re: Loading table from a website which is not in HTML format

You can download xlsx file and use it as data source. Or, you have another faster way is just to select date in the web page, copy and paste it in Qlikview. After replace header column by double clicking with line 1 value (Year, Jan, Feb,..)

sasiparupudi1
Honored Contributor III

Re: Loading table from a website which is not in HTML format

pfa

Untitled.png

LOAD Year,

     Jan,

     Feb,

     Mar,

     Apr,

     May,

     Jun,

     Jul,

     Aug,

     Sep,

     Oct,

     Nov,

     Dec

FROM

[https://data.bls.gov/timeseries/LNS14000000]

(html, codepage is 1252, embedded labels, table is [Series Id: LNS14000000Seasonally AdjustedSeries title: (Seas) Unemployment RateLabor force status: Unemployment rateType of data: Percent or rateAge: 16 years and over

Download:]);

dilema2468
New Contributor

Re: Loading table from a website which is not in HTML format

The .xlsx file will be kept on updating over the time. But I don't want each time to copy and paste the data rather it should automatically pick the latest copy.

dilema2468
New Contributor

Re: Loading table from a website which is not in HTML format

The above works well when the web page is an HTML page but this isn't working for this case.

sasiparupudi1
Honored Contributor III

Re: Loading table from a website which is not in HTML format

sorry I do not understand what your requirement or issue is.. Could you provide me with the problem url and the object that you are wanting to pull into your App?

dilema2468
New Contributor

Re: Loading table from a website which is not in HTML format

Hi Sasidhar,
The problem is that a table is given on this website Bureau of Labor Statistics Data.
I want to load that table in qlikView as we usually do.

table problem.png

Now it is also showing the table structure.

table problem 2.png

And the load script also looks pretty well as usual.
table problem 3.png

After saving this when I go for running it, it throws the following error.

table problem 4.png

I hope the problem statement is clear now.
I just want to load this table.
please help me out .
thanks in advance

Community Browser