Access data from Web Page\Internet

-

Fetch data from Internet

QlikView reads database tables, spreadsheets, XML files, and text files, but did you know that it can also take data from a web page? If you need some standard data from the Internet, there’s no need to create your own version. Just grab it from a web page! How about ISO Country Codes? Here’s an example.

Open the script and click on Web files… below Data from Files on the right-hand side of the bottom section of the screen. This will open the File Wizard: Source dialogue. Enter the URL where the table of data resides:



Then, click on Next; in this case, choose @2 under Tables:















Click on Finish, and your script will look something similar to this:

Now, you’ve got a great lookup table in about 30 seconds—and another few seconds to clean it up for your own purposes. One small caveat though: web pages can change address, content, and structure, so it’s worth putting in some validation around this if you think there could be any volatility.

Comments

Post a Comment

Popular posts from this blog

Qlik Sense Data Reduction (Dynamic)

-
Image
Qlik Sense Data Reduction using Section Access (Dynamic) Qlk Sense supports the dynamic data reduction feature, by which some of the data in an app can be hidden from the user, based on the section access login. • Fields (columns) can be hidden by using the system field OMIT. • Records (rows) can be hidden by linking the section access data with the real data: The selection of values to be shown/excluded is controlled by having one or more fields with common names in section access and section application. After user login, Qlik Sense will attempt to copy the selections in fields in section access to any fields in section application with exactly the same field names (the field names must be written in UPPER CASE). After the selections have been made, Qlik Sense will permanently hide all data excluded by these selections from the user. "All field names used in the transfer described above and all field values in these fields must be upper case, because all fie...
Read more

Understanding Joins

-
Image
JOINS Joins in data model should be used wisely otherwise there may be possibility of things going disastrously wrong. However, it is advisable to keep minimum branches while designing schema. QlikView uses for types of Joins, theoretically it is same as SQL Joins, but there is slight difference in syntax. SQL uses INNER, LEFT, RIGHT and FULL whereas QlikView uses INNER, OUTER, LEFT, JOIN. It’s better to use proper Join wherever necessary. The easiest way to flatten the data model is to join two tables together into one. For a table, where there is a key field and a description, it is very easy to add the description into the main table using a LEFT join (refer to the following section for an example.) Data is joined using all the matching fields in the Load statement, so care must be taken to ensure that all fields needed are included in the Load statement and that any field that is not needed as a link is aliased. A further consideration is that if there are any duplica...
Read more

What is Synthetic Key?

-
Image
Synthetic Key Basics When two or more tables shares more than one common field, QlikView join tables with all fields in common, and this creates an additional table with fields which share both tables. An example of a data model with synthetic keys. Qlikview automatically associates common fields, created a synthetic key or complex key and leading to a third table called $Syn 1 Table. This is the synthetic table which stores the combination of values for the two fields which, form the synthetic key. The synthetic keys in a data model can cause the application to have slow response time and sometimes even consume all available resources. Therefore, need to be avoided when possible.  How to eliminate synthetic keys? There are number of ways, we can avoid QlikView to form Synthetic Key. 1. Using QUALIFY This enforces QlikView to qualify all/selected fields. Qualify implements the check on full path of the field (e.g. Field is created as combination of T...
Read more