I guess I’ll have to play with that. I haven’t needed to do the deduplication in Excel, so haven’t used those features. It seems clunkier than what I’ve been used to doing, but it may work.
Thanks for the suggestion! [cid:[email protected]]Irene Patrick Library & Information Management Systems Librarian, NC Government & Heritage Library NC Dept. of Natural and Cultural Resources 919.814.6788 | [email protected]<mailto:[email protected]> 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. From: Open-ils-general <[email protected]> On Behalf Of Kate Coleman Sent: Tuesday, June 11, 2019 12:15 PM To: Evergreen Discussion Group <[email protected]> Subject: [External] Re: [OPEN-ILS-GENERAL] Duplication in Reports CAUTION: External email. Do not click links or open attachments unless you verify. Send all suspicious email as an attachment to [email protected]<mailto:[email protected]> 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]<mailto:[email protected]> [https://docs.google.com/uc?export=download&id=0B9TS4tJXQ3d3UkpzRGVsWm5rZTQ&revid=0B9TS4tJXQ3d3V2RnZFBpZUZyTHQyblpZdGM3bjlrdTVSdVhRPQ] On Tue, Jun 11, 2019 at 11:12 AM Patrick, Irene <[email protected]<mailto:[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! [cid:[email protected]]Irene Patrick Library & Information Management Systems Librarian, NC Government & Heritage Library NC Dept. of Natural and Cultural Resources 919.814.6788 | [email protected]<mailto:[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.
