# Store reconciliation scores

**URL:** <https://forum.openrefine.org/t/store-reconciliation-scores/707>\
**Category:** Support and Helpdesk\
**Tags:** wikidata, reconciliation\
**Created:** [April 12, 2023, 7:53am UTC](https://forum.openrefine.org/t/store-reconciliation-scores/707 "2023-04-12T07:53:37Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Khaled-M](https://avatars.discourse-cdn.com/v4/letter/k/779978/32.png) [@Khaled-M](https://forum.openrefine.org/u/Khaled-M)\
**Post date:** [April 12, 2023, 7:53am UTC](https://forum.openrefine.org/t/store-reconciliation-scores/707/1 "2023-04-12T07:53:37Z")

</div>

Hi, I did a reconciliation, and I would like to store the reconciliation scores in a new column, can you tell me if I can do that or not or your feedback please?

---

<div class="post-metadata">

**Author:** ![Michael\_Markert](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/michael_markert/32/88_2.png) [@Michael\_Markert](https://forum.openrefine.org/u/Michael_Markert)\
**Post date:** [April 12, 2023, 9:08am UTC](https://forum.openrefine.org/t/store-reconciliation-scores/707/2 "2023-04-12T09:08:50Z")

</div>

Hi, you can, using the cell.recon.candidates variable (see [https://openrefine.org/docs/manual/expressions#reconciliation](https://openrefine.org/docs/manual/expressions#reconciliation)). For example with `forEach(cell.recon.candidates,v,v.name + ", Score: " + v.score).join("; ")` you get a list like this:

 ![Bildschirm­foto 2023-04-12 um 11.07.48](https://europe1.discourse-cdn.com/flex017/uploads/openrefine/original/1X/1a1a76a2f20628abb560b4783af3bbac414a0614.png)

---

<div class="post-metadata">

**Author:** ![Khaled-M](https://avatars.discourse-cdn.com/v4/letter/k/779978/32.png) [@Khaled-M](https://forum.openrefine.org/u/Khaled-M)\
**Post date:** [April 12, 2023, 9:18am UTC](https://forum.openrefine.org/t/store-reconciliation-scores/707/3 "2023-04-12T09:18:16Z")

</div>

> [@Michael\_Markert](#):
>
> forEach(cell.recon.candidates,v,v.name + ", Score: " + v.score).join("; ")

Thank you for your answer, it will help me, but my objective is to store only the score of the best condidate.....the reconciliation wad done and i choosed the best condidate, my aim now is to store the score of my choices ?

---

<div class="post-metadata">

**Author:** ![Michael\_Markert](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/michael_markert/32/88_2.png) [@Michael\_Markert](https://forum.openrefine.org/u/Michael_Markert)\
**Post date:** [April 12, 2023, 9:35am UTC](https://forum.openrefine.org/t/store-reconciliation-scores/707/4 "2023-04-12T09:35:16Z")

</div>

If you always only need the best candidate (the one with the highest score) you can add a column using the code

```auto
cell.recon.best.score

```

while with

```auto
cell.recon.match.score

```

you get the score of the one you chose (even if the scoring value was lower - as long as it was in the list).

---

<div class="post-metadata">

**Author:** ![Khaled-M](https://avatars.discourse-cdn.com/v4/letter/k/779978/32.png) [@Khaled-M](https://forum.openrefine.org/u/Khaled-M)\
**Post date:** [April 12, 2023, 9:42am UTC](https://forum.openrefine.org/t/store-reconciliation-scores/707/5 "2023-04-12T09:42:24Z")

</div>

Thank you Michael\_Markert

---

<div class="post-metadata">

**Author:** ![thadguidry](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/thadguidry/32/653_2.png) [@thadguidry](https://forum.openrefine.org/u/thadguidry)\
**Post date:** [April 13, 2023, 2:20am UTC](https://forum.openrefine.org/t/store-reconciliation-scores/707/6 "2023-04-13T02:20:51Z")

</div>

I think it is documented well enough here:  
[Reconciling | OpenRefine](https://openrefine.org/docs/manual/reconciling#writing-reconciliation-expressions)

Perhaps a few of those bullet points in the docs could add a bit of explanation as @Michael_Markert indicated. Feel free to improve the docs!