Concatenate Column in OpenRefine 3.0 and 3.3

We all know the pain of merging different columns in OpenRefine when you have null values. Before version 3.0, it required writing a complex GREL expression or managing multiple filters to ensure we are not losing any data. 

Those shortcomings have been addressed in the latest version! 

Starting OpenRefine 3.0, we have the coalesce() function:  which natively handles the null correctly. 

But evermore importantly, OpenRefine 3.3 introduced a user interface that offers tons of flexibility, including defining how you want to concatenate one or multiple columns together. 

I recorded a quick video demonstration: 

Read More

merge 2 columns that have both blank cells

New - March 2020 Update:

• OpenRefine 3.0, we have the coalesce() function:  which natively handles the null correctly. 

• OpenRefine 3.3 introduced a user interface that offers tons of flexibility. See tutorial

The basic function to merge or concatenate data from two different column is the following:

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

Read More

How to merge records from different columns

New - March 2020 Update:

• OpenRefine 3.0, we have the coalesce() function:  which natively handles the null correctly. 

• OpenRefine 3.3 introduced a user interface that offers tons of flexibility. See tutorial

This tutorial has been merge with How to merge cells that have blank cells.

You can also refer to the following video tutorials:

Read More