Create one table from two tables

[#1]

Hi,

I have two tabs in an excel sheet. One is called Source and one is called QA Dev Comp. These tabs have the same exact fields with corresponding data underneath. The Source tab is currently left joined into a table called Work Request by the field [%Work Request ID]. I want to combine the two tabs so I can create a single table that has all of the [%Work Request ID]'s from both the Source tab and the QA Dev Comp tab.

I have tried joining the QA Dev Comp tab to the Work Request table as well but it is not working out.

The goal is to not have to merge the tabs in excel and it would be preferred to keep them separate.

Thanks!

[#2]

you can concatenate the tables.

Table1:

load field1,

     field2

from source;

concatenate(Table1)

//table 2

load field1,

     fielda

from source;

[MK9885]

You can use KEEP (Left, Right or Inner) function instead of Join or Concatenate. In this way the 2 tables will not be joined but you'll get same result as Join

Differenc b/w keep & join?

https://community.qlik.com/thread/145170