OpenRefine commands

You can find all GRELL functions in the official OpenRefine wiki.

You can find more examples in this School of Data post.

Data Merging

Add new column to project A, identical to a column in project B, based on a common column between the two projects. In project A, add new column based on Common Column, and add the following code to the terminal:

cell.cross("Project B", "Commom Column").cells["Column to Import from Project B"].value[0]

Merge two columns in the same dataset.

cells["col1"].value + " " + cells["col2"].value

You can find more info and examples on this post.

Data Transform

Transform date field to custom string.

toString(value,"dd/MM/yyyy")

Replace some value.

value.replace("old","new")