two fact tables and separate time and master calender

[Anonymous]

Hi,

i'm trying to remove the synthetic keys from the following data model.

Who can help me with this challenge?

Thanks.

[migueldelval]

Hi mwener87,

If attach an example of your fields, could be better to answer your question.

But the field who has the same name in Date and in FactTable2, change it in one of them and reload. I think thant you only need this step.

Regards

Miguel del Valle

[Anonymous]

Thanks, I will try this.

The fields are like this:

Date(Date)

Time(Time)

FactTable1(FactTable1Id, FactTable1Field, ..., Date, Time)

FactTable2(FactTable2Id, FactTable2Field, ..., Date, Time)

[migueldelval]

Hi mwerner87,

In your case, One opticion could be to make and intervalmatch. Because you are makin synthetics, aren´t you.

Beginners Task Series - Task3(Interval Match)

Interval Match Feature/Function

Interval matching methods

In Qlik it´s better to make link between tables for only one field.

Try to read this documents too.

Synthetic Keys

Do you Qualify?

Regards

Miguel del Valle