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.

[spividori]

Hi Pablo.

The problem could be the Rowno ().

You could attach some sample data to test.

Regards.