Identifying bib records with more than one attached item record

Sierra, Millennium & Encore
1

Hi

I have a list of bib records and I want to find out how many have more than one item record attached. Is it possible to do that in Create Lists?

Thanks

Louise

2

Not directly but you can work with it. You can run a list of items, export out the bib record numbers and item record numbers (sorted by bib number), and then use excel’s subtotal feature to gather the count of how many times each bib # appears (once per item).

1 Like
3

Multi-Item Bib Count.sql (856 Bytes) is one way of doing this in SQL.  Note that in keeping with Louise’s question, this approach is based on the contents of a review file of bibs and not on the bib_record table as a whole.

[edit] I just realized that any duplicate bibs in the source review file will be counted multiple times, so be sure to use the Dedupe button in Create Lists to clean those up first.

1 Like
4

You can do the following:

  1. Export bib rec#, item rec# (bib rec and all attached items)

  2. Name 3rd column “2nd item”

  3. Highlight the header and filter the spreadsheet

  4. Uncheck “Select All” in the “2nd item” header and select “Blank” (at the bottom of the filter list)

  5. Note the number of records showing in the first column - these have only one attached item

  6. Subtract this number from the total number of bib records in your file

I wanted to add a screenshot, but I can’t figure out how to do it on this forum :thinking:

5

Sorry for the delay. Thanks for all your responses. That’s really useful.

1 Like