Point more than 1 location in the map to the same dimention

[Baldaia]

Good morning; 

I have in my data base multiple zips to the same dimention, like this;

Custumer   ShipToZip

XX                123

XX                456

XX                -----

YYY              789

If I try to display it in the map, the custumers that have only 1 zip are displayed, but if it has more than 1, the map does't show anything.

I want to the map to show me all the Zips linked to the same custumer, in different spots

that's the data i'm showing in the map now:

data =[Customer]

Location  =(SHIPTOZIP)&', US'

[y_grynechko · Accepted solution]

Assign dual value to the Customer:

Dual(Customer, ShipToZip) as CustomerLabel

and use CustomerLabel as a dimention on the map. 

[Baldaia]

It works! thanks.

but now all the values associated to my custumers are duplicated, i'm trying to solve it. thanks anyway

[y_grynechko]

the nice way of doing it and not duplicating values is to create additional table.

Create a new table like this: 

CustomerLabel:

Load

Customer,

Dual(Customer, ShipToZip) as CustomerLabel

Resident CustomerTable;

this will allow you to show the labels on the map and shouldn't duplicate the data 🙂