-
-
Re: Loading table from a website which is not in HTML format
Abhishek Soni Apr 16, 2018 3:15 AM (in response to Jean-Baptiste RENAULT)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.
-
-
Re: Loading table from a website which is not in HTML format
Sasidhar Parupudi Apr 15, 2018 1:39 PM (in response to Abhishek Soni)pfa
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:]);
-
298266.qvw 167.5 K
-
Re: Loading table from a website which is not in HTML format
Abhishek Soni Apr 16, 2018 9:18 AM (in response to Sasidhar Parupudi)The above works well when the web page is an HTML page but this isn't working for this case.
-
Re: Loading table from a website which is not in HTML format
Sasidhar Parupudi Apr 16, 2018 1:10 PM (in response to Abhishek Soni)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?
-
-