concatenating tables

[Anonymous]

Hi,

I'd like to concatenate two fact tables which have three common fields but most of the fields from the first table are not shared. Is it possible?

Fields in table 1:

Brands

Advertisers

Subbrands

Media

Month

Category

Vehicle

Cost1

Fields in table 2:

Media

Month

Category

Cost2

I tried:

Concatenate (table1)

load:

Media

Month

Category

Cost2

resident table2;

I failed.

Thank you in advance,

Larisa

[Qrishna · Accepted solution]

You have to create a link table else you will lose the granularity.

Something like this:

[Anonymous]

Thank you!

[Qrishna]

You Welcome.