Combining multiple Facttables

[george55]

Hi all,

Did combine multiples Apps with different datamodels to one App/Datamodel. Each App/Datamodel had its own facttable. 'Date' was the primarykey which exists in all datamodels. Would like to expand the App with 'Team'. Team occurs in all Apps/Datamodels.

How can I bind Team? Changing all Team-Attributenames to the same name will of cource cause circular reference. As I do have multiple facttables and not one usual facttable, do I have to combine all facttables to one? Or what is the best approach?

Thanks for any help.

[Dalton_Ruer]

You can concatenate field values like the following if that solves your problem:

Field1&'-'&Field2 as MyImportantKey

Then simply rename Field1 as Field1ForMyTable1 or whatever. 

You can concatenate your fact tables if most of your fields are identical among them. 

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/LoadData/concat...

Typically I add a "Type" field so that I know which fact "type" the records are. 

Here is a good post about different ways to handle multiple fact tables, the other common way is called a Link Table. (Don't worry about the fact this was created for QlikView the coding is the same.)

https://www.learnallbi.com/link-table-in-qlikview/

[george55]

I do understand the mechanism, only one thing I was unclear: 'Team' is not in the facttables but in the dimensions of the facttables. What now?