5 Replies Latest reply: May 17, 2018 5:03 AM by omar bensalem RSS

    Selection for IF Clause

    satish rathod

      Hello Everyone,

      I have the Following table:

       

      Factory_Code

      1002

      1005
      4001
      4002
      5001
      5009
      6113
      7004
      8001
      8008
      9000
      9001

       

      The expresssion is as follows:

       

      If(WildMatch(Factory_Code,'4*'),'Exclude service center',

      If(Factory_Code='5001' or

              Factory_Code= '9001' or

                  Factory_Code='8001' or

                      Factory_Code='1005' or

                          Factory_Code='8008','Exclude HO',

      If(WildMatch(Factory_Code,'*'),'Standard'))) as Factory_Section.

       

      In this code, I want the third condition to display all the Factory_Codes (i.e. it should include the values of 'Exclude service center' and 'Exclude HO' as well)

       

      The Output should be as follows:

      • Exclude service center = 4001,4002.
      • Exclude HO = 5001, 8001,9001, 1005,8008.
      • Standard = 1002, 1005, 4001, 4002, 5001, 5009, 6113, 7004, 8001, 8008, 9000, 9001.


      However in Future, the Factory_Codes may increase or decrease.

      So wanted the necessary changes to be made in the Code.


      Thanks in Advance.