Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

deepaktibhe
Valued Contributor

finding distinct and duplicate records

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

3 Replies
vikasmahajan
Honored Contributor III

Re: finding distinct and duplicate records

you can upload this tables with flags like

TableA:

Load

     A,

    B,

    C,

     'F1'  as Flag

...

from table a

concatenate

load

Load

     A,

    B,

    C,

   'F2' as Flag

...

from table b

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

Hope this may help you.

Vikas

Re: finding distinct and duplicate records

Hi,

Check the attachment.

elakkians
New Contributor III

Re: finding distinct and duplicate records

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

Community Browser