topic Re: Removing Syn Key from Data Model in QlikView

Removing Syn Key from Data Model

vikasmahajan — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 06 Oct 2017 09:55:16 GMT

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.

kenphamvn — Fri, 06 Oct 2017 09:55:59 GMT

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

Regards,

An Pham

Anonymous — Fri, 06 Oct 2017 10:54:47 GMT

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