remove duplicates

[manoj217]

name	city	amount
manoj	a	200
manoj	a	200
siva	b	300
siva	a	200
vinod	a	100
vinod	b	100

i want delete duplicate value manoj a 200 how can i do this

[Anil_Babu_Samineni]

Qlik can do automatically. Don't required anything here

[YoussefBelloum]

Hi,

Load distinct ...

from

[YoussefBelloum]

Hi loveisfail‌, here if he want to delete the entire duplicated line, if he do nothing, sum(amount) for that line will be 400, I'm I wrong ?

[Anil_Babu_Samineni]

Your way is okay, But his intend is this?

i want delete duplicate value manoj a 200 how can i do this

[YoussefBelloum]

Ok, he put all the line to remove: manoj a 200, so i thought Load distinct will be suitable for his need

[Anil_Babu_Samineni]

hahaha

We are just throwing stones, If he caught then his luck until unless Question was clear

[manoj217]

if we use distinct it wont allow duplicate value in any column it will lose the data but my scenario is diff  i want to delete only manoj row 

[Anil_Babu_Samineni]

What is the o/p from given data?

name	city	amount
manoj	a	200
manoj	a	200
siva	b	300
siva	a	200
vinod	a	100
vinod ABC ABC	b a a	100 500 500

[manoj217]

name	city	amount
manoj	a	200
siva	b	300
siva	a	200
vinod	a	100
vinod	b	100

i want this output because manoj only have duplicate value in all column remaining are different value are there in any column