Fuction Distinct

[pgalvezt]

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.

[CELAMBARASAN]

Try this

GE_PERSONS:

LOAD DISTINCT

  ID,

  PERSON_ID,

     RUT as Rut,

     NOMBRE,

     MASK

     Resident Temp

     WHERE

  EXISTS(PERSON_ID);

[pgalvezt]

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

[pgalvezt]

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

Thanks

[jjordaan]

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;

[pgalvezt]

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.

[jjordaan]

ORDER BY and WHERE must turned arround.

Resident Temp

WHERE RUT = Previous(RUT)

ORDER BY RUT asc;

[pgalvezt]

Still Appears Duplicate Rut's

I Attached the image.

[jjordaan]

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;

[CELAMBARASAN]

Could you post the sanple duplicate data?

Need to know how it look like