[Wactclc-alma] Overlap P and P

[Guidry, Wade]

Colleen,

Here's a short list of titles I found in CPTC that have both DVD and VHS.

I got to this list by using this simple item report I created:

/shared/Community/Reports/Consortia/WACTCLC/Weeding/Simple Item report for use with Excel Pivot Tables

Then exporting the data to Excel and creating a pivot table<https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576>.

You can find pivot tables in Excel under the 'Insert' menu. A pivot table just lets you summarize a table of data.

It's a generally useful tool, and one maybe I can demo on Tuesday.

The analytics report above looks just at 'DVD' and 'Video Cassette' material type items in the AudioVisual location. But you could adjust the criteria to include another locations or material types.

Also, since the different material types look to be on separate title records, this technique won't catch duplicates if the titles used in the two records are not exactly the same.

And the band played on
Endocrine signs & symptoms
Life under pressure
Medical terminology
Needlestick prevention stick to safety /
Skin deep
Taboo.
The Art of listening
The Circulatory system
The Digestive system
The incredible human body
The miracle of life
The Skeletal system
The Universe within
Warnings from the ice
Without pity a film about abilities /


Wade Guidry
WACTCLC
Library Consortium Services Manager
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
http://www.wactclc.org<http://www.wactclc.org/>
509.760.4474

Pronouns: he/him/his


From: Wactclc-alma [mailto:wactclc-alma-bounces at lists.ctc.edu] On Behalf Of Guidry, Wade
Sent: Friday, August 28, 2020 9:25 AM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] Overlap P and P

CAUTION: Originated outside our network. Do not click links or open attachments unless you validate the sender.


I'm not familiar with the canned reports you are looking at. But overlap reports are typically targeted at finding bibliographic record duplicates. That is, 2 or more title records in a catalog with the same bibliographic (not item-level) data.

Trying to find duplicates at the item level is trickier, since items are basically duplicate records "by design". Item records associated with the same title (or at least, the same holding) are usually expected to be duplicates.

Can you give an example of two items that you are trying to identify as duplicates with different material types?

With that info, I could take a closer look.

It might end up being simpler to use holding information. But I'd need to see the records to recommend the best approach.


Wade Guidry
WACTCLC
Library Consortium Services Manager
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
http://www.wactclc.org<http://www.wactclc.org/>
509.760.4474

Pronouns: he/him/his


From: Wactclc-alma [mailto:wactclc-alma-bounces at lists.ctc.edu] On Behalf Of McGaughey, Colleen
Sent: Thursday, August 27, 2020 1:30 PM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] Overlap P and P

I am unfamiliar with doing pivot tables. I will have to look into this more next week. It seems like this information should be possible in the existing canned overlap reports.

________________________________
From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> on behalf of McGaughey, Colleen <Colleen.McGaughey at cptc.edu<mailto:Colleen.McGaughey at cptc.edu>>
Sent: Wednesday, August 26, 2020 3:09 PM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: [Wactclc-alma] Overlap P and P

I have been trying to run an overlap analytic report to see what titles we have on VHS that we also might have on DVD. The Alma Overlap report uses Titles, and unfortunately the only material type available in this overlap report is Bibliographic material type. This means when I go to filter the list, I am unable to select video cassette and DVD. I am only able to select Visual Material. Does anyone know how to work around this?

At some point, I would actually like to include Electronic inventory, but for now, I just wanted to get an idea of what we might have on VHS can that safely be withdrawn from our collection.

Thanks!
Colleen


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200828/640f1a48/attachment-0002.html>