topic Re: Remove duplicates in Resident in QlikView

Remove duplicates in Resident

Fri, 21 Aug 2015 15:00:49 GMT

Hi people!!

Iam trying to remove duplicates in a resident statement with no success.
There is another way to achieve this?

Here i have the the data :

aa	bb	cc
FCH20	FCH20	Innovum
FCH30	FCH30	Creo Antofagasta
FCH10	FCH10	Alimentos
00001000	FCH20	Innovum
00001605	FCH10	Alimentos

NOTE : I want to remove in base of a column called bb.. ( i want to know if it is possible)

My script:

area_grupoceco:

LOAD Distinct

Area_ceco_PEP as aa,

@nombre_area_ceco as bb,

DescripcionArea as cc

Resident Area;

Mensaje editado por: Ivan Diaz

Re: Remove duplicates in Resident

swuehl — Fri, 21 Aug 2015 15:02:15 GMT

And what is your expected result? What do you count as duplicate?

Re: Remove duplicates in Resident

Gysbert_Wassenaar — Fri, 21 Aug 2015 15:02:30 GMT

I don't see any duplicate records in the data you posted. Every record has a unique combination of field values.

Re: Remove duplicates in Resident

maxgro — Fri, 21 Aug 2015 15:03:34 GMT

what's the expected result and why?

Re: Remove duplicates in Resident

alexandros17 — Fri, 21 Aug 2015 15:04:24 GMT

Please explain with more details

Re: Remove duplicates in Resident

Tue, 25 Aug 2015 13:43:41 GMT

i updated my question

Re: Remove duplicates in Resident

swuehl — Tue, 25 Aug 2015 13:49:22 GMT

If you want to keep only the records with first occurence of bb value, you can use NOT EXISTS:

area_grupoceco:

LOAD Distinct

Area_ceco_PEP as aa,

@nombre_area_ceco as bb,

DescripcionArea as cc

Resident Area

WHERE NOT EXISTS(bb,@nombre_area_ceco);

assuming that field bb is not already existing in a different table (loaded before area_grupoceco).

Re: Remove duplicates in Resident

maxgro — Tue, 25 Aug 2015 14:21:56 GMT

Area:

LOAD

aa,

bb,

FROM

[https://community.qlik.com/thread/177501?sr=inbox&ru=15823]

(html, codepage is 1252, embedded labels, table is @1);

area_grupoceco:

NoConcatenate

LOAD

aa,

bb,

Resident Area

where Previous(bb) <> bb // only load the first bb

order by bb, aa;

DROP Table Area;