[OPEN-ILS-GENERAL] [External] Re: Duplication in Reports

[Patrick, Irene]

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 at 01D52050.048141B0]Irene Patrick
Library & Information Management Systems Librarian, NC Government & Heritage Library
NC Dept. of Natural and Cultural Resources
919.814.6788  |  irene.patrick at ncdcr.gov<mailto:irene.patrick at 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-bounces at list.georgialibraries.org> On Behalf Of Kate Coleman
Sent: Tuesday, June 11, 2019 12:15 PM
To: Evergreen Discussion Group <open-ils-general at 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.spam at nc.gov<mailto:report.spam at 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
kcoleman at jeffcolib.org<mailto:kcoleman at 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.patrick at ncdcr.gov<mailto:irene.patrick at 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 at 01D52050.048141B0]Irene Patrick
Library & Information Management Systems Librarian, NC Government & Heritage Library
NC Dept. of Natural and Cultural Resources
919.814.6788  |  irene.patrick at ncdcr.gov<mailto:irene.patrick at 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20190611/970be952/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 8625 bytes
Desc: image001.png
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20190611/970be952/attachment-0001.png>