Skip to Content
0
Jun 19, 2020 at 11:38 AM

Merging 3 data sources with only 1 common dimension each additional each

174 Views Last edit Jun 19, 2020 at 11:38 AM 2 rev

Hi,

So I am lost on this one. In total I have 3 data sources, 1 universe and 2 excel files.

The issue I am having is that in the universe I only got 1 connection per excel file and no connection between all 3 data sources.

Example:

Data source 1 Universe:

Date

Location

Salesperson

# Clients

Data source 2:

Location

Province

Data source 3:

Date

Salesperson

SalesValue

(this is a simplified example of the issue).

So I can merge the value of data source 1 with 2 based on location

And the value of data source 1 with 3 based on Date.

However, if i then want to use all 3 together I get stuck. For example if I put a filter on "Province" my data of Salesvalue is gone or shows the same value in every cell.

How can i get this to work so that all of these data sources work together?

Do I have to create a seperate dimension that sort of combines some of this information?