topic Re: Using Wildcard when creating a bucket in App Development

Using Wildcard when creating a bucket

Anonymous — Wed, 09 Mar 2016 00:01:20 GMT

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

Re: Using Wildcard when creating a bucket

swuehl — Wed, 09 Mar 2016 00:04:11 GMT

Try the WildMatch() function:

Load*,

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

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

Re: Using Wildcard when creating a bucket

sunny_talwar — Wed, 09 Mar 2016 00:28:50 GMT

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 ....