topic Re: remove duplicates in QlikView

remove duplicates

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: remove duplicates

Anil_Babu_Samineni — Mon, 08 Jan 2018 15:08:51 GMT

Qlik can do automatically. Don't required anything here

Re: remove duplicates

YoussefBelloum — Mon, 08 Jan 2018 15:13:09 GMT

Hi,

Load distinct ...

from

Re: remove duplicates

YoussefBelloum — Mon, 08 Jan 2018 15:15:23 GMT

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 ?

Re: remove duplicates

Anil_Babu_Samineni — Mon, 08 Jan 2018 15:18:41 GMT

Your way is okay, But his intend is this?

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

Re: remove duplicates

YoussefBelloum — Mon, 08 Jan 2018 15:22:13 GMT

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

Re: remove duplicates

Anil_Babu_Samineni — Mon, 08 Jan 2018 15:24:19 GMT

hahaha

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

Re: remove duplicates

manoj217 — Mon, 08 Jan 2018 15:36:30 GMT

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

Re: remove duplicates

Anil_Babu_Samineni — Mon, 08 Jan 2018 15:38:25 GMT

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

Re: remove duplicates

manoj217 — Tue, 09 Jan 2018 06:06:19 GMT

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

Re: remove duplicates

Anil_Babu_Samineni — Tue, 09 Jan 2018 06:08:51 GMT

Even, ABC also same.

Where you want to work? In script/UI?

Re: remove duplicates

manoj217 — Tue, 09 Jan 2018 06:15:23 GMT

In script only i want to delete these duplicate values

Re: remove duplicates

Anil_Babu_Samineni — Tue, 09 Jan 2018 06:18:27 GMT

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

];

Re: remove duplicates

neha_shirsath — Tue, 09 Jan 2018 09:41:04 GMT

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

Re: remove duplicates

sasikanth — Tue, 09 Jan 2018 10:28:55 GMT

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

siva-b-300

siva-a-200

vinod-a-100

vinod-b-100

If there are any other constraints pls let us know