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]

Even, ABC also same.

Where you want to work? In script/UI?

[manoj217]

In script only i want to delete these duplicate values

[Anil_Babu_Samineni]

Hi Man, What r u talking about? Can you simply load this and show the output you are getting and what you are expecting

Load * Inline [

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

];

[neha_shirsath]

You just simply need to load this table, qlikview will remove duplicate.

[sasikanth]

HI Manoj,

I think your perception is wrong here as Load DISTINCT definitely allows duplicate values for individual fields , it always works on the combination of all fields in the table.

It removes the duplicate combination from the table.

ex:

manoj-a-200

manoj-a-200

siva-b-300

siva-a-200

vinod-a-100

vinod-b-100

If there are any other constraints  pls let us know