Restricting data from a web file

[Qlik_Enthu]

Dear All,

I am loading a map data (csv) from here: https://developers.google.com/public-data/docs/canonical/countries_csv] . Is it possible to restrict the data in other words, is it possible to add a where condition in the data load script?

[ahaahaaha]

Hi,

Example

LOAD country,

    latitude,

    longitude,

    name

FROM

[https://developers.google.com/public-data/docs/canonical/countries_csv]

(html, codepage is 1251, embedded labels, table is @1)

Where name= 'Andorra' Or name='Armenia';

[Qlik_Enthu]

I wanted to select Where Country_Code using the IN clause. but when I add where condition the query wouldn'`t work

[tresesco · Accepted solution]

Qlikview's replacement for IN could be Match(). Try like:

...Where  Match(Country_Code, 'Code1', ....)

[Kushal_Chawda]

or go on to this link and export the file into CSV and load it in QlikView

https://opendata.socrata.com/dataset/Country-List-ISO-3166-Codes-Latitude-Longitude/mnkm-8ram/data

[Qlik_Enthu]

Thank you so much..it worked