topic Re: Create one table from two tables in QlikView

Create one table from two tables

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Create one table from two tables

Mon, 01 Aug 2016 17:06:10 GMT

you can concatenate the tables.

Table1:

load field1,

field2

from source;

concatenate(Table1)

//table 2

load field1,

fielda

from source;

Re: Create one table from two tables

MK9885 — Mon, 01 Aug 2016 17:21:02 GMT

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