This is the RefinePro knowledge base about OpenRefine. We build it over the years, and keep adding to it. From great tutorials and how-to, to handy GREL expressions and links to external resources, you will find here one of the most comprehensive list of resources to learn OpenRefine.

For a comprehensive documentation you should refer to the official OpenRefine wiki.

Don't where to get started? Search for a specific function below, or read our most popular article from the right side menu.

28.8.20

OpenRefine August 2020 Review

9:19 AM  

 Here is a summary of all the interesting tutorials and videos published about OpenRefine through August. Do not forget to subscribe to our newsletter to get our monthly update right in your mailbox.


Read More
Read more »

29.7.20

OpenRefine July 2020 Review

6:34 PM  

Here is a summary of all the interesting tutorials and videos published about OpenRefine through July. Do not forget to subscribe to our newsletter to get our monthly update right in your mailbox.

Read More
Read more »

30.6.20

OpenRefine June 2020 Review

4:01 PM  

Here is a summary of all the interesting tutorials and videos published about OpenRefine through June. Do not forget to subscribe to our newsletter to get our monthly update right in your mailbox.

Read More
Read more »

1.6.20

OpenRefine May 2020 Review

2:31 PM  

The May edition of our OpenRefine news rounds-up is ready.

Do not forget to subscribe to our newsletter to get our monthly update right in your mailbox. 

Read More
Read more »

4.5.20

OpenRefine April 2020 review

10:35 AM  


April was a busy month for the OpenRefine community with new reconciliation services and plugin updates! Do not forget to subscribe to our newsletter to get our monthly update right in your mailbox. 

Read More
Read more »

30.3.20

OpenRefine March 2020 review

12:14 PM  

The latest edition of the OpenRefine review is ready. Through March the community published a LOT of new video tutorials in six languages! 

Do not forget to subscribe to our newsletter to get our monthly update right in your mailbox. 

Read More
Read more »

29.3.20

Concatenate Column in OpenRefine 3.0 and 3.3

3:04 PM  , ,


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
Read more »
Subscribe to: Posts (Atom)