1 Reply Latest reply: Oct 17, 2016 7:42 PM by John Witherspoon RSS

    How to use WHERE in load statement?

    Jim Chan

      Hi guys,

       

      I want to filter this table with another condition ,  only show me  data from company_id which is 1,2,3,4,5. how should i put it in my where statement, as below:

       

      table1:

      load*

      FROM

      [..\QVD\BASE\FACT_table1_*.qvd] (qvd)

      where (name <> 'Nick' and country <> 'Thailand' and company_id = '1,2,3,4,5');

       

      It didnt work.

       

      Rgds,

       

      Jim