<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:DengXian;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"\@DengXian";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">The function you are looking for is “cross()”: https://github.com/OpenRefine/OpenRefine/wiki/Recipes#combining-datasets<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="color:#1F497D">---</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Bin Zhang</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Digital Information Services Librarian</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Library Systems & IT Services, University Library</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">California State University, Sacramento</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">+1 (916) 278-5664 | <a href="mailto:bzhang@csus.edu"><span style="color:#954F72">bzhang@csus.edu</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Zoom: https://csus.zoom.us/my/bzhang<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:12.0pt;color:black">From:
</span></b><span style="font-size:12.0pt;color:black">Eril-l <eril-l-bounces@lists.eril-l.org> on behalf of Harper, Cynthia <charper@vts.edu><br>
<b>Date: </b>Wednesday, March 10, 2021 at 11:25 AM<br>
<b>To: </b>eril-l (eril-l@lists.eril-l.org) <eril-l@lists.eril-l.org><br>
<b>Subject: </b>[Eril-l] OpenRefine again<o:p></o:p></span></p>
</div>
<p class="MsoNormal">Hi all – I’ve now used OpenRefine to create one file that is an ISBN|a index of my print books, and a second file that is an ISBN|z index of my ebooks. Now I want to ompare the files, which may or may not be something you can do in OpenRefine.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">In Excel, I would do a VLOOKUP on the cells in the print-ISBN|a column into the ebook-isbn|z. How can I do a comparable thing in OpenRefine?<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Cindy Harper<o:p></o:p></p>
<p class="MsoNormal">Electronic Services and Periodicals Librarian<o:p></o:p></p>
<p class="MsoNormal">Virginia Theological Seminary, Box 159<o:p></o:p></p>
<p class="MsoNormal">3737 Seminary Road<o:p></o:p></p>
<p class="MsoNormal">Alexandria, VA 22304<o:p></o:p></p>
<p class="MsoNormal"><a href="mailto:charper@vts.edu">charper@vts.edu</a><o:p></o:p></p>
<p class="MsoNormal">(703)461-1794<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</body>
</html>