I have a second tsv file (Project2) with several columns out of which I want to import only a couple of selected ones into my existing project in OpenRefine. In some previous releases of OpenRefine, there was the option of “import from another project” but in recent releases this has apparently been decommissioned. I need a GREL command to be able to do this operation for as many columns as I desire.
Project1
| Column A | Column B |
|---|---|
| id_1 | value1 |
| id_2 | value2 |
Project2
| Column C | Column D | Column E | Column F |
|---|---|---|---|
| id_1 | value_x | value_z | value_u |
| id_2 | value_y | value_v | value_t |
Expected merged project
| Column A | Column B | Column E | Column F |
| ——– | ——– | ——– | ——– |
| id_1 | value1 | value_z | value_u |
| id_2 | value2 | value_v | value_t |
I found a similar solution here but it works for importing only one column.