5 Replies Latest reply: Feb 26, 2018 5:12 AM by ABHIJIT PRADHAN RSS

    MULTIPLE FILTER CONDITION

    ABHIJIT PRADHAN

      SELECT * FROM

      Table 1,

      Table 2

       

      where

      (

      Table2."PRODUCT_CODE" in ('400', '500', '600')

      and

      "Table 1"."AMOUNT_FLAG" in ('s', 'd')

      and

      case  when ("Table 1"."AMOUNT_TYP" in ('Credit', 'Debit')) then "Table 1".AMOUNT else 0 end  <> 0

      or

      "Table2"."PRODUCT_CODE" in ('600', '410')

      and

      "Table 1"."AMOUNT_FLAG" in ('i', 'c', 's')

      and

      "Table2"."PRODUCT_NUM" <> '203'

      or

      "Table2"."PRODUCT_NUM" = '203'

      and

      "Table1"."AMOUNT_FLAG" in ('s', 'd')

      and

      case  when ("Table 1"."AMOUNT_TYP" in ('Credit', 'Debit')) then "Table 1"."AMOUNT" else 0 end  <> 0 )

       

      -----This is my query .So, my question is that how can i write this filter condition into load script editor ??

      ----can i handle this filter into sheet ??

      ----tell me the exact expression for this filter condition