6 Replies Latest reply: Sep 5, 2018 10:10 AM by Gabor Tarnoczai RSS

    Include values in list...?

    Raman Singh

      Hi All,

       

      I am trying to create a column which can then be used as an expression in a table. Below is what I would like but I am not sure how this is written.

       

      Data Load Editor

      LOAD

          orderid,

          type,

          IF(type= Match(type,'ZBC','XQC','XQH'),1,0) as TypeFlag

      FROM [lib://L1-Tracking.qvd]

      (qvd);


      Table

      Sum({<TypeFlag= {1}>}TypeFlag)

       

      This will then filter my table for only the above-listed types.

       

      Thank you in advance.