Help with creating new dimension using like/not like

[chiso_chiso]

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

[swuehl]

Try

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

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

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

               if ( [Service] Like '*Sale*', 'Sale', 'Other')))) as ServiceType

[sunny_talwar]

Try this may be:

If([Service] Like '*Admin*', 'Admin', If([Service] Like '*Complaint*', 'Complaint', If([Service] Like '*Claim*', 'Claim', If([Service] Like '*Sale*', 'Sale','Other')))) as ServiceType

[chiso_chiso]

Thank you so much. It worked

[sasiparupudi1]

= if ( lower([Service]) Like '*admin*', 'Admin', if ( lower([Service]) Like '*complaint*', 'Complaint', if ( lower([Service]) Like '*claim*', 'Claim', if ( lower([Service]) Like '*sale*', 'Sale', 'Other')))) as ServiceType

[sasiparupudi1]

please close this thread by marking the correct answer

[jonathandienst]

Another option

Pick(WildMatch(Service, '*Admin*', '*Complaint*', '*Claim*', '*Sale*') + 1, 'Other', 'Admin', 'Complaint', 'Claim', 'Sale')