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:

       

      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