Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_jagan
Partner - Creator
Partner - Creator

Remove Duplicates from multiple tables in qlikview

Table1:

Date

AmtId
Jan-121a
Feb-122a
Mar-123a
Apr-124a
May-125a
Jun-126a
Jul-127a
Aug-128a
Sep-129a
Oct-1210a
Nov-1211a
Dec-1212a
Jan-1313a
Feb-1314a
Mar-1315a
Apr-1316a
May-1317a
Jun-1318a

Table2:

DateAmtId
Jan-1313b
Feb-1314b
Mar-1315b
Apr-1316b
May-1317b
Jun-1318b
Jul-1319b
Aug-1320b
Sep-1321b
Oct-1322b
Nov-1323b
Dec-1324b

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;

0 Replies