Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Specialist III
Specialist III

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
Master III
Master III

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

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

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

sasiparupudi1
Master III
Master III

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?

Anonymous
Not applicable
Author

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