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.
you can upload this tables with flags like
'F1' as Flag
from table a
'F2' as Flag
from table b
And use set analysis with flag 'F1' & 'F2' to find duplicate.
Hope this may help you.
Check the attachment.
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 .
Retrieving data ...