How to handle Duplicate records in Qlikview ??

[nikhilgarg]

Hey,

1. How to handle Duplicate records in Qlikview ??

Thanks

[crusader_]

Hi,

LOAD Distinct ....

I suppose.

Hope this helps.

Andrei

[rajeshvaswani77]

Hi,

You can use Rowno() function to make the duplicate records unique in case that's what you are looking for.

Example

Load *, RecNo( ), RowNo( ) from tablename;

thanks,

Rajesh Vaswani

[richard_pearce6]

Interview question?

Distinct would be the obvious. You have to be careful when joining tables which don't have a distinct key as they will cause duplicate rows in the original table.

Trick is to keep checking your data after everything you change in the script.

Rcihard

QlikCentral.com

[nikhilgarg]

HEy,

Cann't i use Distinct keyword ?? And what is this RecNo( ), RowNo( ) used for ??

What does this RecNo( ), RowNo( ) returns ??

Thanks

[crusader_]

Check this document

http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/29/recno-or-rowno

Hope this helps.

Andrei

[ychaitanya]

Use Distinct(Field) during load

[jagan]

Hi,

If you want to remove duplicate then use Duplicate keyword like below

LOAD DISTINCT

*

FROM Table1;

Data:

LOAD DISTINCT

A

FROM Table1

WHERE NOT EXISTS(A);

Regards,

Jagan.

[nikhilgarg]

HEy,

How does RecNo() and RowNo() helps in handling dupliacte records ??