I have a three tables with the follwoing charesterics 1. Some attributes are common on all table or in two tables. 2. Having common date filelds and some unique date fields. Im having difficulty in modeling how to combine the common fields.
I'm trying to achive 1. Avoid SYNC table and 2. Create a master calender combining all date fields (common or unique files) .
From a technical standpoint you can simply make sure that the link between your table consists of only one field. But i would recommend by asking yourself how you want your sheets to relate to each other. What do you want to achieve?
Regarding dates. You have several date columns, ask yourself which one of them you want to be the link to your Master calender table.
Common between [WIN 8 OS Updates] and JET campain tables
TOEM,
[Code Name],
Date(LeadExit, 'MM/DD/YYYY') as LeadExit,
Date(TestApprove, 'MM/DD/YYYY') as TestApprove,
Date([Availability Date],'MM/DD/YYYY') as Availability_Date,
Active,
Devices_Updated,
[Update Mechanism] AS Platform,
Size_MB,
in Sum_2012 there are the common fileds with above
TOEM,
[Code Name],
Pushed AS Devices_Pushed,
Updated AS Devices_Updated,
Platform,
Size_MB,
Im having difficulty in link all dates (common and unique) to a master tables. Let me know if im thinking wrong. Please let me know if you have any questions.
See there are three different reports on same business unit and trying to build a demo presentation using qlikview. Im sure they will ask me to add 7 more to this one after the demo.
Since i have multiple dates, some of them are in common and some don�t.
If i look at your questions: Yes. I will build 2 different sheet one for each table. I want to link most of the date fields to master calender, so i can show the data from multiple ways (dates). Please let me know if you have any questions.
Concatenate the common fields of the three sheets onto one master table and use [Code name] as the foreign key. The dates which arent common need to have different names.
