topic Remove Duplicates from multiple tables in qlikview in QlikView

Remove Duplicates from multiple tables in qlikview

qv_jagan — Wed, 20 Aug 2014 12:08:26 GMT

Table1:

Date	Amt	Id
Jan-12	1	a
Feb-12	2	a
Mar-12	3	a
Apr-12	4	a
May-12	5	a
Jun-12	6	a
Jul-12	7	a
Aug-12	8	a
Sep-12	9	a
Oct-12	10	a
Nov-12	11	a
Dec-12	12	a
Jan-13	13	a
Feb-13	14	a
Mar-13	15	a
Apr-13	16	a
May-13	17	a
Jun-13	18	a

Table2:

Date	Amt	Id
Jan-13	13	b
Feb-13	14	b
Mar-13	15	b
Apr-13	16	b
May-13	17	b
Jun-13	18	b
Jul-13	19	b
Aug-13	20	b
Sep-13	21	b
Oct-13	22	b
Nov-13	23	b
Dec-13	24	b

Test:

LOAD Date&'-'&Amt as Key,

Date,

Amt,

Id,

RowNo() as RowNo

FROM

Table1.xls

(biff, embedded labels, table is Sheet1$);

LOAD Date&'-'&Amt as Key,

Date,

Amt,

Id,

RowNo() as RowNo

FROM

Table2.xls

(biff, embedded labels, table is Sheet1$);

Test1:

LOAD RN;

LOAD Key as Key1,

Min(RowNo) as RN

Resident Test

Group By Key;

Left Join (Test1)

LOAD Key,

Date,

Amt,

Id,

RowNo as RN

Resident Test;

Drop Table Test;