MARCEDIT-L Archives

December 2013

MARCEDIT-L@LISTSERV.GMU.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Terry Reese <[log in to unmask]>
Reply To:
MarcEdit support in technical and instructional matters <[log in to unmask]>
Date:
Sat, 21 Dec 2013 12:31:19 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (58 lines)
So, let me try and understand.  You want to take the two files and merge
them together so you get a unique file of records?  Is that what you are
looking to do?  If it is, use the Dedup records tool.  From the main window,
Tools/Dedup Records.  You'd select the two files, and match on the control
number.  That should create a file of unique records.  If you are looking to
get a set of unique records, but with some data from the duplicate record
merged into the unique record, you could use the merge record tool, but you
need to join the two files you want to process together with MARC Join.
Then in the Merge tool, select the source file, and then check process
source file -- this will both merge and dedup the data in the source file.
Use MARC21 for matching -- and then sit back and wait -- because this is
going to get a long time to process.  MarcEdit merge tool uses a lot of
matches and will need to track a lot of data and store large trees of data
in memory -- so it will definitely take a while to process.

Does that help?  I'm not sure -- because I'm not completely sure I
understand what you are trying to do :)

--tr

-----Original Message-----
From: MarcEdit support in technical and instructional matters
[mailto:[log in to unmask]] On Behalf Of Bothmann, Robert L
Sent: Saturday, December 21, 2013 11:02 AM
To: [log in to unmask]
Subject: [MARCEDIT-L] how do I merge files to include all records

I'm trying to compare the unique vs. shared records across 7 institutions.
My thought for how to do this was to get the OCLC numbers from each
institution, add a unique identifier for the institutions, and then merge
the records and see which 001s with OCLC numbers end up with more than one
institution identifier. However, I can't seem to get two files to fully
merge.

So I have two files, one with 345,904 records (A) and one with 792,935
records (B). I want to merge them such that the unique records in both files
end up in the merge file along with the merged records. I thought if I use A
as the source and B as the merge then when the resulting file has at least
792,935 records then I will have been successful. But I can't figure out how
to do this. None of the merges will let me.

Is there a way to do this, or a better method anyone might know of?

Thanks,
Bobby Bothmann

________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical
and instructional support in MarcEdit.  If you wish to communicate directly
with the list owners, write to [log in to unmask] To
unsubscribe, send a message "SIGNOFF MARCEDIT-L" to
[log in to unmask]

________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]

ATOM RSS1 RSS2