Data Bridge Two tables and two date link and Canonical Date

[krmvacar]

Hi All,

I have two tables. I am connecting two tables with a field.

But due to date difference, there is an error in connecting. How can I establish a connection here?

I want to table1 result for date  table1 and and table2 result for table 2 result.

My data model;

My result:

can you help me please?

[deepanshuSh]

First create two link tables each based on the resident of the two different facts table and then concatenate them together to create a final table, using that in the master calendar creation. 

[PrashantSangle]

Hello,

What is your expected output? it's difficult to understand from your question.

Can you explain with  some sample data?

Regards,

Prashant Sangle