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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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