# Reconcile many values into single entity

**URL:** <https://forum.openrefine.org/t/reconcile-many-values-into-single-entity/1117>\
**Category:** Support and Helpdesk\
**Tags:** wikidata, reconciliation\
**Created:** [December 12, 2023, 5:40am UTC](https://forum.openrefine.org/t/reconcile-many-values-into-single-entity/1117 "2023-12-12T05:40:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Podbrushkin](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/podbrushkin/32/775_2.png) [@Podbrushkin](https://forum.openrefine.org/u/Podbrushkin)\
**Post date:** [December 12, 2023, 5:40am UTC](https://forum.openrefine.org/t/reconcile-many-values-into-single-entity/1117/1 "2023-12-12T05:40:33Z")

</div>

I need to reconcile csv with authors. A common task. Column looks like that:

```auto
Александр Дюма
Александр Дюма
Александр Дюма.
Дюма Александр
Дюма, Александр
Сельма Лагерлёф
Лагерлеф Сельма
Лагерлёф Сельма
Лагерлёф, Сельма
Сельма Лагерлеф

```

What I did first: applied clustering and reconciled produced unique names.  
I've found out reconciliation result was not so good. I think it would be better if it would take into considerations not a single final unique name produced by clustering, but all known invariants of this name. Is it possible? How can it be done?  
I can try joining all invariants into list into single column, but it doesn't seem right.  
Original data structure is not important, I can transform it freely. Thanks in advance.  
Also, if some effective technique exists for this common task which will make my original question irrelevant, feel free to share!

---

<div class="post-metadata">

**Author:** ![Lucas.Belo](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/lucas.belo/32/698_2.png) [@Lucas.Belo](https://forum.openrefine.org/u/Lucas.Belo)\
**Post date:** [December 23, 2023, 11:33pm UTC](https://forum.openrefine.org/t/reconcile-many-values-into-single-entity/1117/2 "2023-12-23T23:33:59Z")

</div>

Hello Podbrushkin, an alternative would be to create a column for each alternative name and then reconcile each column using facets so as not to do the same reconciliation more than once. For example:

| name | alias1 | alias2 | alias3 |
| --- | --- | --- | --- |
| Александр Дюма | Alexandre Dumas | Dumas Davy de la Pailleterie | ... |

The first reconciliation would be in the name column, after that activate the facet to only have the rows that were not reconciled, then reconcile the alias1 column and repeat the process as many times as necessary