topic filter load table in QlikView

filter load table

bilionut — Sat, 10 May 2014 09:15:17 GMT

Hi,

I guess it's elementary stuff but I fail to find the correct solution

From a table like this:

I want to load only the rows that contain the '#' character in field Name

Thanks,

Ionut

swuehl — Sat, 10 May 2014 09:39:45 GMT

Is '#' always the last character, when contained in the record?

LOAD KEY, Name FROM Table.xls WHERE RIGHT(Name,1) = '#';

or use a search

LOAD KEY, Name FROM Table.xls WHERE Name LIKE '*#*';

its_anandrjs — Sat, 10 May 2014 09:53:33 GMT

You can use Wildmatch() also see the load script

Source:

LOAD * Inline

[

KEY, Name

1, Abhgh UIUjkj#

2, Akljhka

3, JHKGHJG #

4, Kljijihh#

5, Abhgh

];

NewTable:

NoConcatenate

LOAD

KEY,Name

Resident Source

WHERE WildMatch(Name,'*#*');

DROP Table Source;