- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
sql and table
Hello,
I have the cities in a table, when I use the "where City = 'Bangkok' "then qlikview shows all cities.
Do you know what I can do that I only get bangkok and not all cities?
Can someone help me?
The code is:
Land1:
LOAD Land,
City,
FROM
Gegevensbronnen\Land1.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq, no eof)
WHERE City = 'Bangkok';
thanks in advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I would have to see the format of the fields in the file, but have you tried playing with file delimiter properties
something like
(txt, codepage is 1252, embedded labels, delimiter is ',')
WHERE City = 'Bangkok';
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try
where wildmatch(City, '*Bangkok*')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
maybe
WHERE City like '*Bangkok*';
could do if there are some other characters included in this field.
regards
Marco
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try:
WHERE Trim(Upper(City)) = 'BANGKOK'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Don't create duplicate post