<div dir="ltr">I am not sure exactly if this is what you mean. You can filter by owning library if you just need from a certain library. Is the owning library on the record branch specific? You may try filtering by circulating library if not.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Sep 8, 2023 at 12:20 PM Elizabeth Davis via Evergreen-reports <<a href="mailto:evergreen-reports@list.evergreen-ils.org">evergreen-reports@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg6394447187325015288">
<div lang="EN-US" style="overflow-wrap: break-word;">
<div class="m_6394447187325015288WordSection1">
<p class="MsoNormal">Hello<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I’m looking to run a report to for a list of TCNs for a library system where 2 of the 3 libraries own copies, but the 3<sup>rd</sup> location doesn’t own a copy. I’m looking for TCNs where libraries A and B are the only libraries that
own copies. I have list of TCNs and copy counts, but I’m having a hard time filtering out instances where all three libraries own copies or where library C and A or library C and B own copies.
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Has anyone done this type of report or any ideas on how I can filter in either Excel/Sheets or using OpenRefine?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks! <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal" style="vertical-align:baseline"><u></u><img width="83" height="83" style="width: 0.8645in; height: 0.8645in;" src="cid:image002.png@01D9E257.4074AA40" align="left" hspace="12"><u></u><b><span style="color:rgb(22,105,122)">Elizabeth
Davis</span></b><b><span> </span></b><span>(she/her),
<b><i><span style="color:rgb(22,105,122)">Support & Project Management Specialist</span></i></b></span><span style="font-size:12pt;color:rgb(22,105,122)"> </span><span style="font-size:9pt;font-family:"Segoe UI",sans-serif"><u></u><u></u></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><b><span style="font-size:12pt;color:rgb(51,102,204)">Pennsylvania Integrated Library System
</span></b><b><span style="color:rgb(68,114,196)">(PaILS) | SPARK</span></b><span style="font-size:12pt;color:rgb(51,102,204)"> </span><span style="font-size:9pt;font-family:"Segoe UI",sans-serif"><u></u><u></u></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="color:rgb(51,102,204)">(717) 256-1627</span><span> |
</span><span><a href="mailto:katherine.dannehl@sparkpa.org" target="_blank"><span style="color:rgb(5,99,193)">elizabeth.davis@sparkpa.org</span></a></span><span> <br>
</span><span><a href="https://support.sparkpa.org/" target="_blank"><span style="color:rgb(5,99,193)">support.sparkpa.org</span></a></span><span style="color:rgb(51,102,204)"> |
</span><span><a href="mailto:support@sparkpa.org" target="_blank"><span style="color:rgb(5,99,193)">support@sparkpa.org</span></a></span><span style="color:rgb(51,102,204)"> </span><span style="font-size:9pt;font-family:"Segoe UI",sans-serif"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org" target="_blank">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
</div></blockquote></div><br clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div style="border:0px;font-family:"Carrois Gothic",sans-serif;font-size:12.8px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;color:rgb(38,38,38);line-height:24px">Tony Miller</div><div style="border:0px;font-family:"Carrois Gothic",sans-serif;font-size:12.8px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;color:rgb(38,38,38);line-height:24px"><span style="color:rgb(0,0,0);font-family:Calibri;font-size:small;background-color:rgb(255,255,255)"><b>User Services Coordinator </b></span><br></div><div style="border:0px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;line-height:24px"><div style="color:rgb(38,38,38);font-family:"Carrois Gothic",sans-serif;font-size:12.8px;border:0px;margin:0px;outline:0px;padding:0px;vertical-align:baseline"><div style="border:0px;font-size:12.8px;margin:0px;outline:0px;padding:0px;vertical-align:baseline"><div style="font-family:"Open Sans",sans-serif;font-size:18px;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(68,67,64)"><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><img src="https://pbmldstaff.files.wordpress.com/2022/03/01.png" alt="01" width="182" height="118" style="height: auto; max-width: 100%;"></div><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px">318 North Main Street | Poplar Bluff, MO 63901<br>(573) 686 – 8639</div><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><span style="font-weight:700"><a href="https://poplarbluff.org/" rel="noopener" style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(21,182,184)" target="_blank">Website</a> | <a href="https://poplarbluff.org/OTS.pdf" rel="noopener" style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(21,182,184)" target="_blank">Newsletter</a> | <a href="https://poplarbluff.org/annualreport.html" rel="noopener" style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(21,182,184)" target="_blank">Annual Report</a> | </span><span style="font-weight:700"><a href="http://poplarbluff.org/downloads.html" rel="noopener" style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(21,182,184)" target="_blank">Digital Library</a></span><span style="font-weight:700"> </span></div><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"> </div><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><p style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px 0px 1.6em;padding:0px;vertical-align:baseline;border:0px;outline:0px"><span style="font-weight:700"><i><span style="font-family:garamond,"times new roman",serif;font-size:large;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><span style="font-family:inherit;font-size:18px;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"></span></span></i></span><i style="font-size:revert;color:initial"><span style="font-family:inherit;font-weight:700;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px">Promoting Libraries to Make Our Communities Stronger</span></i></p><div style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><div style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px">Poplar Bluff Municipal Library District with its community partners provides and promotes equal access to reading, information, cultural and intellectual resources.</div></div></div></div></div></div></div><div style="border:0px;font-family:"Carrois Gothic",sans-serif;font-size:12.8px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;color:rgb(38,38,38);line-height:24px"></div></div></div></div></div></div></div>