2 Replies Latest reply: Mar 8, 2016 7:28 PM by Sunny Talwar RSS

    Using Wildcard when creating a bucket

    Rocco Pecora

      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