11 Replies Latest reply: Sep 13, 2015 10:25 AM by PAUL YEO RSS

    How to add another filter for limit loadf

    PAUL YEO

      Hi All

       

      I have below script , which can filter BRAND_SUB=HAKKO from sales Table :-

       

      NewFilteredTable:

      NOCONCATENATE

      LOAD *

      RESIDENT sales WHERE BRAND_SUB='HAKKO';

       

      DROP TABLES sales;

       

      In my QVW file i have 2 table , which is ARSummary Table , and i also want to filter another field , SEGMENT=Other.

       

      Hope some one can advise me how to modify the above , so that it can filter more then 1 table.

       

      Paul