Would deduplicating the column in Excel work? I have to do that a lot with some of my reports. I find that reports generally give the information I need, but I have to manipulate the returned information into what I want in Excel.
Kate Coleman Jefferson County Library - Central Services Technical Services Specialist 5678 State Rd. PP High Ridge, MO 63049 636-677-8689 Fax: 636--677-1769 [email protected] On Tue, Jun 11, 2019 at 11:12 AM Patrick, Irene <[email protected]> wrote: > I have another, more general, question about reports in Evergreen. Some > reports return information that is duplicated. When we were on our > previous ILS, I could use SELECT DISTINCT to eliminate rows where all the > information was duplicated. Is there any way to do that in Evergreen > reports? Now that I’m starting to need more complicated reports, it would > sure be helpful to be able to get rid of the duplicates. > > > > Thanks for any advice you can share! > > > > > > *Irene Patrick * > > Library & Information Management Systems Librarian, NC Government & > Heritage Library > > NC Dept. of Natural and Cultural Resources > > 919.814.6788 | [email protected] > > *(Please note new phone number)* > > > > 109 E. Jones Street | 4640 Mail Service Center > > Raleigh, North Carolina 27699-4600 > > Facebook <http://www.facebook.com/ncghl> Instagram > <https://www.instagram.com/foreverythingnc/> Twitter > <https://twitter.com/ForEverythingNC> YouTube > <https://www.youtube.com/statelibrarync> Website > <https://statelibrary.ncdcr.gov/> > > > > *Email correspondence to and from this address is subject to the North > Carolina Public Records Law and may be disclosed to third parties.* > > >
