topic "Where not equal" not working in script load in QlikView

"Where not equal" not working in script load

Tue, 11 Feb 2014 18:17:35 GMT

I'm creating a table (let's say table "temp") and then concatenating on to temp using data from another source in my script load. In the concatenate() load, I use a where clause to tell QV not to pick up any rows where there is a "Total" string of any sort in column 1 (using where <> '*Total*'). My script looks like below:

Temp:

Load

some data...

...

From source1;

Concatenate(Temp)

Load

Additional data...

...

From source2

WHERE Field1 <> '*Total*';

For some reason, the script is ALWAYS loading the "Total" rows. If I change it to WHERE Field1 = '*Total*' the NONE of the line items from source2 will load. Any ideas why this is the case?

Re: "Where not equal" not working in script load

swuehl — Tue, 11 Feb 2014 18:20:38 GMT

Try

From source2

WHERE not Field1 like '*Total*';

Re: "Where not equal" not working in script load

maxgro — Tue, 11 Feb 2014 18:21:25 GMT

try with

WHERE not wildmatch(Field1, '*Total*')

Re: "Where not equal" not working in script load

Tue, 11 Feb 2014 18:25:25 GMT

Wow... so simple. I knew this was elementary. Thanks for the help!