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:image001.png@01D52050.048141B0]Irene Patrick
Library & Information Management Systems Librarian, NC Government & Heritage 
Library
NC Dept. of Natural and Cultural Resources
919.814.6788  |  irene.patr...@ncdcr.gov<mailto:irene.patr...@ncdcr.gov>

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 <open-ils-general-boun...@list.georgialibraries.org> On 
Behalf Of Kate Coleman
Sent: Tuesday, June 11, 2019 12:15 PM
To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org>
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 
report.s...@nc.gov<mailto:report.s...@nc.gov>

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
kcole...@jeffcolib.org<mailto:kcole...@jeffcolib.org>

[https://docs.google.com/uc?export=download&id=0B9TS4tJXQ3d3UkpzRGVsWm5rZTQ&revid=0B9TS4tJXQ3d3V2RnZFBpZUZyTHQyblpZdGM3bjlrdTVSdVhRPQ]


On Tue, Jun 11, 2019 at 11:12 AM Patrick, Irene 
<irene.patr...@ncdcr.gov<mailto:irene.patr...@ncdcr.gov>> 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:image001.png@01D52050.048141B0]Irene Patrick
Library & Information Management Systems Librarian, NC Government & Heritage 
Library
NC Dept. of Natural and Cultural Resources
919.814.6788  |  irene.patr...@ncdcr.gov<mailto:irene.patr...@ncdcr.gov>
(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.

Reply via email to