3 Replies Latest reply: May 30, 2017 11:34 AM by Mark Graham RSS

    filter data in script

    Mark Graham

      Hi All,

       

      I'm trying to separate my data by its status: Please see attached qvw

       

      Here is the sample data:

        

      SALES_IDNameStatus
      1A0
      1A1
      1B0
      1B1
      1C0
      1D0
      1E0
      1F0
      1G0
      1G1

      2                    A                    0

      2                    A                    1

      2                    B                    0

      2                     C                    0

       

      For SALES_ID 1,

      I want to bring just C,D,E,F in my new column as it doesn't have Status  1

       

      For SALES_ID 2,

      I want to bring just B,C in my new column as it doesn't have Status 1

       

      Any help is highly appreciated!