Heisenbug with reconciling multi-value cells in OpenRefine 2.8

[Alan Orth]

Hello,

I seem to be having a bug with OpenRefine 2.8 on macOS while reconciling multi-value cells, but can't quite put my finger on it: reconciled values seem to revert back to their original value after joining the multi-value cells.

My process is the following:

1. Split multi value cells

2. Start reconciliation

3. Select matches

4. Join multi-value cells

5. Export CSV

When I inspect the exported CSV I see a handful of values that should have been corrected during reconciliation. The first time it happened I though I must have missed them, so I split the multi-value cells and reconciled them again, carefully selecting all matches so that the green reconciliation bar was 100% green. Yet again, after joining the multi-value cells and exporting the records again I see the old, un-reconciled values!

Am I crazy? Am I doing something wrong? Should I file a bug on the GitHub issue tracker?

Thank you,

--

Alan Orth
alan...@gmail.com
https://picturingjordan.com
https://englishbulgaria.net
https://mjanja.ch

[Ettore Rizza]

Hi,

When you perform a reconciliation, the content of the matched cell does not change. It turns blue and its contents change in appearance, but it's still the same cell actually. To extract the term matched, you have to create a new column using the Grel  formula:

cell.recon.match.name

In the same way, you can extract the matched ID using:

cell.recon.match.id

The documentation for the "recon" objects is here.

Hope this helps.

Ettore

[Alan Orth]

Thanks, Ettore. You're right. Somehow I missed this! It seems obvious in hindsight.

Cheers,

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.