topic Re: Where in load doesn't seem to work?? in QlikView

Where in load doesn't seem to work??

Mon, 11 Aug 2014 07:42:14 GMT

Hi guys!

I have a problem that I don't understand.

I have a table actions, I want to seperate that table into A_actions and P_actions

(action category starts with an 'a' or a 'p')

This is what I wrote in my script:

FROM

[..\2. Extraction to QVD layer\QVD_Ivla\Actions_Ivla.qvd]

(qvd)

where LEFT(action_category,1) = 'a' AND _address_id = '2153359';

the address_id is an extra test.

Because in attachment you can see the result, I have a lot more records than that address_id and where the action category starts with an a.

Can anyone explain to my why this is?

Kind regards,

Katleen

DavidFoster1 — Mon, 11 Aug 2014 07:46:25 GMT

Can you paste the LOAD portion of your statement and can you confirm that the field Address_Id is not loaded in any other part of your script.

The other thing to do is not use a table-box for data checking but to use the data preview in the data model view.

Mon, 11 Aug 2014 07:50:53 GMT

The address_id is a foreign key and they are all loaded through the primary key in the addresses table.

Seems logical now!

thank you

DavidFoster1 — Mon, 11 Aug 2014 09:19:03 GMT

No problem. Glad to help.