Type of Join

[#1]

Hi All,

I have 2 fact tables representing 2013 and 2014 data. I would like to merge these 2 tables to create one fact table. What is the best join to use (all 2013 + all 2014), and what would the syntax of the code look like in an upload statement.

Thank you

[MK_QSL · Accepted solution]

If both table have same column name no need to join... qlikview will automatically concatenate them...

[#3]

Perfect thanks