How to import Excel file for new data

Stefano_Mazzocca

In my environment I have cities and I can correctly view them in a map layout.

I need to view them grouped as regions but regions are not in the system so I want to try to use an Excel sheet to group cities in regions.

I'm not sure if this will help to display regions instead of cities in my map layout so I have 2 questions:

1. Will it be helpful?
2. How can I import such Excel file?

Thank you

Benjamin Arnulf-Oracle

1. Yes it could be helpful to have all the cities having the same COLOR for the region. The benefit is that you will continue to have the city boundaries and granularity while having the region identifier.
2. See below:
   
   a. Create an Excel File
   b. Put the below format for example:
   
   Region ID | Region Name | City
   1 | Lombardy | Milan
   2 | Lazio | Rome

That being said, I would also recommend to just import as a map layer in the console a Geo json file with Italy regions so you can automatically use as a custom map layer:

Visualizing Data and Building Reports in Oracle Analytics Cloud

I believe you have another post on this question and might get specific help on it.

Stefano_Mazzocca

Hi @Benjamin Arnulf-Oracle , your link was really helpful, I was able to reproduce this map :)

Now I just need to know how to connect the Excel I imported to system data, in order to associate headcounts by region. I see that subject area "HCM - Workforce Core" is not linked with my file:

and because of this I cannot relate the 2 sources of data:

do you have any further hint to share?

I would really appreciate

—> Update: To link 2 different sources it is sufficient to click "Data" in the top-center of the screen and add there the fields

Benjamin Arnulf-Oracle

@Stefano_Mazzocca First, good job! I see your progress since few posts and you quickly become an analytics expert!

Yes - It's easy as going to the "Data" tab at the top and create a "Join" between the SA (Subject Area) and the Excel file, using a common field (aka "Attribute"), usually the City Name or City ID.