topic Re: Fuction Distinct in QlikView

Fuction Distinct

pgalvezt — Mon, 02 Sep 2013 16:39:01 GMT

Hi,

I would like to know how eliminate duplicates into my table (RUT);

I have this;

Temp:

LOAD

RowNo() as ID,

PERSON_ID,

NUMBER_ID as RUT,

NAME_ as NOMBRE,

MASK

FROM

$(RutaQlikviewQvd)Ruta.QVD(qvd)

WHERE

EXISTS(PERSON_ID);

GE_PERSONS:

LOAD

ID,

PERSON_ID,

Count(Distinct RUT) as Rut,

NOMBRE,

MASK

Resident Temp

WHERE

EXISTS(PERSON_ID);

Drop Table Temp;

Still appears the duplicates,

Thank you for your help.

Re: Fuction Distinct

CELAMBARASAN — Mon, 02 Sep 2013 16:55:40 GMT

Try this

GE_PERSONS:

LOAD DISTINCT

ID,

PERSON_ID,

RUT as Rut,

NOMBRE,

MASK

Resident Temp

WHERE

EXISTS(PERSON_ID);

Re: Fuction Distinct

pgalvezt — Mon, 02 Sep 2013 17:09:10 GMT

Hi, thank you for you reply, I already tried before. But Doesn't work.

Re: Fuction Distinct

pgalvezt — Mon, 02 Sep 2013 17:24:09 GMT

Or if you have another way to do this. I would appreciate.

Thanks

Re: Fuction Distinct

jjordaan — Mon, 02 Sep 2013 18:16:49 GMT

Hi Pablo,

I would expect it should work celambarasan said.

Maybe you can try something with previous function;

Temp:

LOAD

RowNo() as ID,

PERSON_ID,

NUMBER_ID as RUT,

NAME_ as NOMBRE,

MASK

FROM

$(RutaQlikviewQvd)Ruta.QVD(qvd)

WHERE

EXISTS(PERSON_ID);

GE_PERSONS:

LOAD

ID,

PERSON_ID,

IF(RUT = Previous(RUT), 1,0),

NOMBRE,

MASK

Resident Temp

ORDER BY RUT

WHERE RUT = Previous(RUT);

Drop Table Temp;

Re: Fuction Distinct

pgalvezt — Mon, 02 Sep 2013 19:36:54 GMT

Gave an error

Unrecognized words after the sentence. (This happened with the Where Sentence)

But when I take off the where sentence QlikView Load well. But still with duplicates rut.

Thank you.

Re: Fuction Distinct

jjordaan — Mon, 02 Sep 2013 19:48:06 GMT

ORDER BY and WHERE must turned arround.

Resident Temp

WHERE RUT = Previous(RUT)

ORDER BY RUT asc;

Re: Re: Fuction Distinct

pgalvezt — Mon, 02 Sep 2013 20:16:31 GMT

Still Appears Duplicate Rut's

I Attached the image.

Re: Fuction Distinct

jjordaan — Mon, 02 Sep 2013 20:18:35 GMT

So but try this

GE_PERSONS:

LOAD

ID,

PERSON_ID,

IF(RUT = Previous(RUT), 1,0),

NOMBRE,

MASK

Resident Temp

ORDER BY RUT

WHERE RUT <> Previous(RUT);

Drop Table Temp;

Re: Fuction Distinct

CELAMBARASAN — Mon, 02 Sep 2013 20:22:18 GMT

Could you post the sanple duplicate data?

Need to know how it look like

Re: Fuction Distinct

spividori — Mon, 02 Sep 2013 20:28:41 GMT

Hi Pablo.

The problem could be the Rowno ().

You could attach some sample data to test.

Regards.