Merging three tables in data load

[Evan0211]

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?

[rwunderlich · Accepted solution]

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