topic select data from two tables in QlikView

select data from two tables

Tue, 29 Sep 2015 07:51:25 GMT

Hi experts,

I have two tables, T1 and T2 as below,

T1:

T2:

Then, I want to find out the same sales from T2 when sales name is same as T1. What about the scripts for this?

Display result in T2 :

Sales
A
C

Thanks

Jessica

Gysbert_Wassenaar — Tue, 29 Sep 2015 09:47:18 GMT

MyTable:

LOAD Sales FROM table1;

INNER JOIN

LOAD Sales FROM table2;

avinashelite — Tue, 29 Sep 2015 09:49:24 GMT

if you don't want the table to get merge use the INNER KEEP

MyTable:

LOAD Sales FROM table1;

INNER KEEP

LOAD Sales FROM table2;

nagarjuna_kotha — Tue, 29 Sep 2015 10:00:39 GMT

PFA....