Dimension Crunching :-)

[Anonymous]

I have a dimension called "Lead Source"

some examples of each are THY DAT LBC etc 

I have one called LBC but it also has variants LB4, LB5, LB6, LB7 all under lead source

I want to take LBC, Lb4, Lb5, LB6, LB7 and make them all one , they could all be LBC

is there a way to merge these into one? 

They are all under Dimension called "Lead Source"

Thanks

[Anonymous]

Sounds like you need to look at wildmatch - script and chart function ‒ Qlik Sense

Maybe something this in the load script

     if ( Wildmatch ( [Lead Source] , 'LB*' ) , 'LBC' , [Lead Source] )

The function is case insensitive.

[OmarBenSalem]

Yes; it would be sthing like:

in script:

load

field1;

field2,

...

'LBC' as NewLeadSource

from source where "Lead Source" in (LBC, Lb4, Lb5, LB6, LB7 );

concatenante

in script:

load

field1;

field2,

...

"Lead Source" as NewLeadSource

from source where "Lead Source"not in (LBC, Lb4, Lb5, LB6, LB7 );

or in front end; create a new master dimension like follow:

     if ( Wildmatch ( upper([Lead Source]) , 'LB*' ) , 'LBC' , [Lead Source] )

[Anonymous]

That worked perfectly! Thank you.