Trouble creating Wikidata qualifiers from multiline records

I have trouble creating Wikidata imports with multiple qualifiers of the same type when the dataset has multiple rows per record.

The dataset can look like this


The schema like this

and the desired output like this

and this

The one with qualifiers fails to create more than one per item, or creates multiple statements and other variations. The only way I can succeed is to export to QuickStatements for import.

Very interesting problem!

What statement matching settings are you using for this statement? You can reach them by clicking on the "configure" button in the schema editor.

Intuitively, if you are using the "Property and value" mode, which should be enabled by default, OpenRefine should merge together all the statements you are adding and so that should have the desired effect. But it can well be the matching is only done against existing statements and not between the added ones, which would explain why the statements end up being duplicated. In that case we should create a bug report for that.

Also note that we made some fixes to this statement matching recently, so it's worth using the latest version if you are relying on the specifics of those settings.

I have tried changing them without help. It is of course possible that I have missed some specific configuration, but I have still consistently failed. I will update to the latest version.

I think this is a real problem. Because a user could want both option, that is having separate values with one qualifier for each, or to combine them in one values, and having many of the same qualifiers (with different values).

I think this come back to defining a tree structure in table data.

Regards, Antoine