Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Qlikview's replacement for IN could be Match(). Try like:
...Where Match(Country_Code, 'Code1', ....)
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';
I wanted to select Where Country_Code using the IN clause. but when I add where condition the query wouldn'`t work
Qlikview's replacement for IN could be Match(). Try like:
...Where Match(Country_Code, 'Code1', ....)
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
Thank you so much..it worked