Forum Discussion

NCLSOG's avatar
NCLSOG
Regular Visitor
2 years ago
Solved

Problem to display emplacement defined in different columns on a map

Hello, 

 

I want to place on the map different emplacements.

 

My localisations  are defined in 5 different columns. 

 

LocalitionAPM_VILLE_1APM_VILLE2APM_VILLE3APM_VILLE4
PARISROMERIO JANEIROLOS ANGELESTORONTO
NEW YORKTOKYOROME  
DUBLIN    

 

I've added the 5 columns in the field emplacement. (see screenshot below 1 / 2 / 3 / 4 / 5) 

 

But, only the first column is taked in consideration and displayed on the map. The informations are not cumulated. 

 

How can display the cities saved in the different columns ?

 

Thx for your feedback

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi NCLSOG,

    I'd like to suggest you do 'unpivot columns' on these fields, then you cna use attribute and value fields to design visualization instead of the values that stored from multiple value fields.

    Unpivot columns - Power Query | Microsoft Learn

    Regards,

    Xiaoxin Sheng