How to link both table with all dimensions

[nevilledhamsiri]

Hi,

Could you please see why Province is not coming when the both tables are loaded?

Thanks In advance

Neville

[andrey_krylov]

Hi, I think there must be a relationship between two tables, some common field.

TABLE1:

LOAD PROVINCE, SALES, CommonField

FROM (ooxml, embedded labels, table is Sheet1);

TABLE2:

LOAD COUNTRY, CITY, POPULATION, CommonField

FROM (ooxml, embedded labels, table is Sheet1);

Then you can join them or leave as they are.

[trdandamudi]

I see it loaded in the Table view:

[jyothish8807 · Accepted solution]

Hi Neville,

It is not possible to create an  association (link both tables) based on the data you have.

You must find a relation between Provience and Country or city.

Br,

KC