topic Re: Load with exception in QlikView

Load with exception

Fri, 09 Jan 2015 16:53:20 GMT

Hi,

I am trying to write a conditional Load script of the kind:

Load *,

where PO_Number <> '12345';

Basically I am trying to load all data to a table except the rows with the PO_Number 12345. I'd appreciate guidance in this aspect. I believe I might have syntax issues most likely.

Thank you!

Deep

Re: Load with exception

its_anandrjs — Fri, 09 Jan 2015 17:01:57 GMT

Hi,

Try

Ex:-

Source:-

Load * From Location Where PO_Number <> '12345';

Source:
Load * From Location;

Noconcatenate

Load * Resident Source Where PO_Number <> '12345';

Drop table Source;

Regards

Anand

Re: Load with exception

Gysbert_Wassenaar — Fri, 09 Jan 2015 17:03:39 GMT

Your load statement is missing a FROM clause to specify where the source data should come from. And if you're loading all the field using the * and not creating any new fields then the comma after the * should be removed too:

LOAD *

FROM MySourceTable

WHERE PO_Number <> '12345'

;

And if the field PO_Number contains numeric values instead of text values then use WHERE PO_Number <> 12345 (without the quotes).

Re: Load with exception

Fri, 09 Jan 2015 17:11:56 GMT

I tried the same but I keep getting the following error:

Re: Load with exception

Gysbert_Wassenaar — Fri, 09 Jan 2015 17:14:09 GMT

Then the field name is not PO NUMBER. Qlikview is case sensitive with regards to field names so. PO Number is not the same as PO NUMBER.

Re: Load with exception

its_anandrjs — Fri, 09 Jan 2015 17:22:14 GMT

Hi,

It seems you mix the <> symbol with the field name also check you are using correct name and you are used it

Where [PO Number]<> '12345';

It Will be

Source:-

Load * From Location

Where [PO Number] <> '12345';

Regards

Anand

Re: Load with exception

Fri, 09 Jan 2015 18:22:32 GMT

I used the wizard to write the query and that worked well for me. What seems to have worked was a pair of brackets after the Where Clause.

Thank you for your help!