topic Re: finding distinct and duplicate records in QlikView

finding distinct and duplicate records

deepakqlikview_123 — Wed, 15 Jun 2016 05:13:39 GMT

Hi all,

Pfa

I have 2 tables having same structure. I need to find out duplicate records and distinct records amongst them.

Can you please suggest how should I go ahead.

Thanks

vikasmahajan — Wed, 15 Jun 2016 05:20:38 GMT

you can upload this tables with flags like

TableA:

Load

'F1' as Flag

...

from table a

concatenate

load

Load

'F2' as Flag

...

from table b

And use set analysis with flag 'F1' & 'F2' to find duplicate.

Hope this may help you.

Vikas

tamilarasu — Wed, 15 Jun 2016 05:35:09 GMT

Hi,

Check the attachment.

elakkians — Wed, 15 Jun 2016 05:46:50 GMT

Hi,

AutoNumber(RecNo(),Field) as Field1

this will create a auto number, if there is a reputation.

if the field value is distinct you will get 0 in field1 else you will get auto number generated the number of times the field value is repeated .

Thanks