6 Replies Latest reply: Sep 22, 2015 9:57 AM by Jonathan Dienst RSS

    Help with creating new dimension using like/not like

    Harrison Chisonga

      Guru,

      I have a script as below;

       

      if ( [Service] Like '*Admin*', 'Admin',

            if ( [Service] Like '*Complaint*', 'Complaint',

            if ( [Service] Like '*Claim*', 'Claim',

            if ( [Service]Like '*Sale*', 'Sale',

            if (not [Service] like ('*Sale*','*Admin*','*Complaint*','*Claim*')),'Other')))) as ServiceType

       

      Apparently the 'Other' is not being created. Kindly assist