Let me preface this with I do not have direct access to the data outside of the Data Load in Qlik.
I have three tables that hold the same information (though it is called something different in each).
Table 1
ID,
Data_Release_Date
Table 2
ID,
Release_Date
Table 3
ID,
Expected_Release_Date
I would like to merge these three tables into one to make things more streamlined but I keep getting Synthetic Keys.
Like this:
Release:
ID,
Release Date
and have all three tables merged into the Release table.
Any ideas?
