klasusers.com logo

Welcome, Guest
Username: Password: Remember me

TOPIC: How to find Missing Information

How to find Missing Information 3 months 1 day ago #604

  • patrick20k
  • patrick20k's Avatar
  • OFFLINE
  • Administrator
  • KLAS Technical Writer
  • Posts: 124
  • Thank you received: 24
  • Karma: 9
Queries in KLAS make it easy to find records that meet certain criteria. Unfortunately, it can be harder to search by what isn't there.

For example:
Maybe you want to find all of the books by a certain narrator that don't have the Foreign Accent subject heading.
Or maybe you want to find all of your patrons that are Active for cassettes but not for DB.

Computer logic is just not very good at that kind of thing... but there's still a way!

The attached HowTo has step-by-step instructions for comparing two sets of records in Excel, in order to find out which records are missing something. And of course: let us know if you need help!
Attachments:
The administrator has disabled public write access.
Moderators: Andrea, patrick20k
Time to create page: 0.095 seconds