Using Wildcard when creating a bucket

[Anonymous]

Hello Qlik users.

I'm creating buckets in a preceding load but with text values not numerical.

So currently it looks like:

     Load*,

       if([ImplementationProjectType]='Credit-Brand Flip','Credit',

               if([ImplementationProjectType]='Credit-Conversion','Credit',

                          if([ImplementationProjectType]='Debit-Existing','Debit','Other'))) as Imp_Type;

Is there a way to use wildcard(*) instead of writing each out value. I tried a couple ways and couldn't get it to work. If someone could help with the syntax to be able to utilize '*Credit*' somehow instead of writing that would great.

Thanks so much

[swuehl · Accepted solution]

Try the WildMatch() function:

  Load*,

       if(WildMatch( [ImplementationProjectType], '*Credit*'),'Credit',

                          if([ImplementationProjectType]='Debit-Existing','Debit','Other')) as Imp_Type;

[sunny_talwar]

In addition to doing it Stefan's way, you can also do it this way:

LOAD *,

          If(ImplementationProjectType LIKE '*Credit*', 'Credit',

          If(ImplementationProjectType = 'Debit-Existing', 'Debit', 'Other'));

LOAD ....