Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Use Concatenate to build a single table.
Release:
Load
ID,
Data_Release_Date as "Release Date"
From ...;
Concatenate (Release)
Load
ID,
Expected_Release_Date as "Release Date"
From ...;
etc
-Rob
Use Concatenate to build a single table.
Release:
Load
ID,
Data_Release_Date as "Release Date"
From ...;
Concatenate (Release)
Load
ID,
Expected_Release_Date as "Release Date"
From ...;
etc
-Rob