Discussion Board for collaboration on QlikView Scripting.
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:
[..\2. Extraction to QVD layer\QVD_Ivla\Actions_Ivla.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?
Go to Solution.
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.
The address_id is a foreign key and they are all loaded through the primary key in the addresses table.
Seems logical now!
No problem. Glad to help.