finding distinct and duplicate records

[deepakqlikview_123]

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]

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

[tamilarasu]

Hi,

Check the attachment.

[elakkians]

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