may i know how to remove the $Syn Table ?

[paulyeo11]

Hi All

My data model as below , may i know how to remove the $Syn Table ?

[Hemanth458]

Rename Date in both tables as TableName_Date then go canonical date.

[paulyeo11]

Hi Sir

Now the table look nice.

May I know how to link all table date to master calendar ?

Paul

[Hemanth458 · Accepted solution]

Please go through this link https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

[paulyeo11]

Hi Sir

Wow this is the better approach .

Paul Yeo

[paulyeo11]

Hi All

I move this post to the top . As i am solving this issue now.

Paul