2 Replies Latest reply on Jun 8, 2016 11:34 AM by Gurpreet Singh Goraya

    Group Attributes

    Gurpreet Singh Goraya

      Hello I have the following table

      Pass type.jpg

      I want to group all Pass Type in three categories like (CLI1), (CLI!,CU61)... as clients, and (CLI1,CU61), (CU61),... as Child and so on. To do this I have created bins but I didn't get success. My bins are not counting accordingly. Here are the bins details:

       

      IF [Passengertype] =  "CLI1" OR [Passengertype] = "(CLI1,CU61)" OR [Passengertype]= "(CLI1,CU61,ESC1)"OR [Passengertype] ="(CLI1,CU62)" OR [Passengertype]="(CLI1,ESC1)" OR [Passengertype]="(CLI1,ESC1,MA1)"OR [Passengertype]="(CLI1,ESC2)" OR [Passengertype]="(CLI1,MA1)" OR [Passengertype]="(CLI2,ESC1)" OR [Passengertype]="(CLI2)" OR [Passengertype]="(CLI3)"  then "Client"

      ELSEIF

      [Passengertype]="MA1" OR [Passengertype]="(CLI1,ESC1,MA1)" OR [Passengertype]="(CLI1,MA1)" OR [Passengertype]="(ESC1,MA1)" then "Mandatory"

      Elseif

      [Passengertype]= "ESC1" OR [Passengertype]="(CLI1,CU61,ESC1)" OR [Passengertype] ="(CLI1,ESC1)" OR [Passengertype]="(CLI1,ESC2)" OR [Passengertype]="(CLI2,ESC1)" OR [Passengertype]="(ESC1,MA1)" then "Escort"

      Elseif

      [Passengertype]="CU61" or [Passengertype] ="(CLI1,CU61)" OR [Passengertype] ="(CLI1,CU61,ESC1)" OR [Passengertype]="(CLI1,CU62)" then "Child"

      ELSE " NOT DEFINED "

      END

       

      The result I am getting

      2016-06-08_10-07-13.jpg

      As you see in the last screenshot that the results are same as shown in the first screenshot. I want to add every item that has CLI1 or CLI2 or CLI3 or combination of CLI and others as shown in the bins as clients. I would appreciate the advice. Thanks

      GG