[Eril-l] OpenRefine again

[Zhang, Bin]

The function you are looking for is “cross()”: https://github.com/OpenRefine/OpenRefine/wiki/Recipes#combining-datasets

---
Bin Zhang
Digital Information Services Librarian
Library Systems & IT Services, University Library
California State University, Sacramento
+1 (916) 278-5664 | bzhang at csus.edu<mailto:bzhang at csus.edu>
Zoom: https://csus.zoom.us/my/bzhang



From: Eril-l <eril-l-bounces at lists.eril-l.org> on behalf of Harper, Cynthia <charper at vts.edu>
Date: Wednesday, March 10, 2021 at 11:25 AM
To: eril-l (eril-l at lists.eril-l.org) <eril-l at lists.eril-l.org>
Subject: [Eril-l] OpenRefine again
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.

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?

Thanks,

Cindy Harper
Electronic Services and Periodicals Librarian
Virginia Theological Seminary, Box 159
3737 Seminary Road
Alexandria, VA 22304
charper at vts.edu<mailto:charper at vts.edu>
(703)461-1794

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.eril-l.org/pipermail/eril-l-eril-l.org/attachments/20210310/1dd3b823/attachment.html>