Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jgarciaf106
Creator
Creator

WildMatch Grouping

Hi Experts,

I am Wondering if this is possible or if any suggestions I could have to accomplish the following:

I have the following Countries which I need to Group into Clusters:

Argentina  And Uruguay should by Group as Arg + Uru

Costa Rica ,Barbados ,Bahamas ,El Salvador ,Guatemala    ,Honduras    Jamaica      Group as Caricam                     

Chile  ,Colombia  ,Ecuador ,Peru, Venezuela Group as Pacific


I achieved that by using Wildmatch, but I am Wondering if its possible to create an additional group that holds all countries mentioned into a new group named Latam.


I attempted with Wildmatch and did not Work


Any Suggestion?



Thanks,

2 Replies
CarlosAMonroy
Creator III
Creator III

Hi Andres,

I guess you have to create either an other field to add that group or duplicate data and have it in the same field.

Carlos

nsetty
Partner - Creator II
Partner - Creator II

Does this work?

CountryTable:

Load * Inline [

COUNTRY, ADDITIONAL GROUP, GROUP

Argentina, Latam, Arg + Uru

Uruguay, Latam, Arg + Uru

Costa Rica,Latam, Caricam

Barbados,Latam, Caricam

Bahamas,Latam, Caricam

El Salvador,Latam, Caricam

Guatemala,Latam, Caricam

Honduras,Latam, Caricam

Jamaica, Latam, Caricam                   

Chile,Latam, Pacific

Colombia,Latam, Pacific

Ecuador,Latam, Pacific

Peru,Latam, Pacific

Venezuela,Latam, Pacific

];