Skip to content

Instantly share code, notes, and snippets.

@evanwill

evanwill/openRefineTips.md

Created August 31, 2016 18:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save evanwill/ff6ea2422174e5fc6de9765a802a6647 to your computer and use it in GitHub Desktop.
Save evanwill/ff6ea2422174e5fc6de9765a802a6647 to your computer and use it in GitHub Desktop.
Download ZIP
openrefine tips
Raw
openRefineTips.md

Handy OpenRefine Functions to Remember

OpenRefine Cross function

Use cross to retrieve columns from other OpenRefine projects based on a common column.

  1. Open the two projects you want to join

  2. Identify the common column to be used as a key. Ensure that it is a unique identifier, or cross won't work how you expect. You can create a new unique column on both projects by adding an index number an existing common column (on common column > Add column based on this column... > value + "-" + row.index ).

  3. On the project where you want to import values, go to the key column you identified, and Add column based on this column...

  4. In the expression window, put:

cell.cross("name_of_other_project", "name_of_key_column").cells["name_of_column_you_want_to_import"].value[0]

You should have a new column that has the correct values from the other project.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment