how to eliminate the duplicate rows in qlikvew

[#1]

how to eliminate the duplicate rows in qlikvew

id	name
1	a
1	a
2	b
2	c
3	d

i want to o/p like this

1 a

2 b

3 d

eliminates the duplicates in id.

[rubenmarin]

Ah, ok, that would't work either. All id values are already in INPUT table, so 'where not exists('id', id);' is always FALSE and doesn't load any record in OUTPUT Table.

To do this you need to change the name of the input or the output id field or create a check field:

OUTPUT:

NoConcatenate LOAD

  id,

  idCheck,

  name

Resident INPUT where not exists('idCheck', id);

DROP Table INPUT;

DROP Field idCheck;

[peschu123]

Yes, thank you.

That was my point.

[#4]

I follow you but it is not working. My script and my data is.

[PrashantSangle]

Hi,

I did not see any duplicate row.

for every same id you have different name, then how it could be duplicate?

Regards,