3 Replies Latest reply: Aug 11, 2014 5:19 AM by David Foster RSS

    Where in load doesn't seem to work??

      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:



      [..\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?


      Kind regards,