Removing Syn Key from Data Model

[vikasmahajan]

Hi all

I have 2 fact tables with date and master calender . I wanted to link  2 fact tables with Master calender using Calderday date field

can anyone guide how to link this 2 fact with one master calender

Thanks

Vikas

[YoussefBelloum]

Hi,

Usually, you can use a Concatenation, to just concatenate these 2 Fact tables to have one physical Fact connected with your Master Calendar.

Find attached the modified Script, you can see the concatenation just after the Load of the second Fact table.

YB

[kenphamvn]

Hi

You can combine two key fields like Key&CalendarDay as NewKey

or using autonumber function for generate new key from two fields key autonumber( Key&CalendarDay) as NewKey

after that, remove two fileds Key,CalendarDay from RSP tables or FactSales base on requirement 

Synthetic keys ‒ Qlik Sense

Regards,

An Pham

[Anonymous]

Hii Vikas Mahajan,

You should Use LinkTable Concept For This,

First create Composite Key in both Fact Tables

Then Create a Period Key in Master Calendar

and Keep this two  keys in LinkTable.

Regards,

Akash Gaikwad