This content has been marked as final. Show 3 replies
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?