Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil-kumar5
Creator II
Creator II

Multiple Tables with redundant data

Hi Everyone,

I have five tables and all have duplicate records and null values. There is no master table.

1. License Information Table - Installation Date and Due Date- Common field  id is CODE 

2. Calls Table - Created Date - Common field id is CODE

3. Missed Call Table - DATE -  Common field CODE

4. Reference Table - Reference Date - Common field is CODE

Now my problem is I want to create a single year and month filter works for all table and well connected with each other.

Do I need to create 4 master calender and link these 4 master calender with Date bridge and create canonical date?

Or any other way is there to resolve it.

Thanks

Sunil Kumar

Labels (1)
2 Replies
BrunPierre
Master
Master

IMO, I suggest you utilize the 4 master calendars as it may help answer follow on questions.

It's further elaborated here: Canonical Dates  

marcus_sommer

You may just concatenate all tables by harmonizing the date-fields, like:

t: load CODE, [Created Date] as Date, 'Created' as Datetype, 'Licence' as Source from Licence;
concatenate(t) load CODE, [Due Date] as Date, 'Due' as Datetype, 'Licence' as Source from Licence;
concatenate(t) load CODE, [Created Date] as Date, 'Created' as Datetype, 'Calls' as Source from Calls;
...

- Marcus