WildMatch Grouping

[jgarciaf106]

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,

[CarlosAMonroy]

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]

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

];