topic Re: Delete Duplicates in table in QlikView

Delete Duplicates in table

Mon, 12 Jan 2015 15:51:40 GMT

Hello,

I have a table like this:

A	A-TEST
C	TEST
B	B-TEST
C	C-TEST

I want to delete lines to get a table like this:

A	A-TEST
B	B-TEST
C	C-TEST

When you have two lines with the same key (first column), just preserve the last one.

Can someone help me on this please?

Thanks,

Regards,

Loïc

Re: Delete Duplicates in table

Clever_Anjos — Mon, 12 Jan 2015 15:57:32 GMT

T:
LOAD F1,F2,-RecNo() as Ord INLINE [
    F1, F2
    A, A-TEST
    C, TEST
    B, B-TEST
    C, C-TEST
];

LOAD
  F1 as Final,
  F2
Resident T
Where not Exists(Final,F1)
order by Ord;


drop table T;

Re: Delete Duplicates in table

Mon, 12 Jan 2015 16:27:35 GMT

Also in Presentation Tab, Select the 'Final' column and check 'Omit Rows Where Field is NULL'.