Text->Fuzzy

Instructions for use

Settings window

“Layers” field

The “Layers” field displays the list of loaded layers, limited to geopackage tables and postgis tables.

“Attributes” field

Once the layer has been selected, this drop-down menu displays all of its text fields.

Load unique values

The Load unique values button loads the different values present for the selected field into the mapping table.

You can enter the fuzzy value (0 – 1) for each of the values present.

Save table

The Save table button offers two options:

  • a CSV file

  • a mapping table saved in the source database

The Save to Database option creates the table if it does not exist, and overwrites it with the new values if it already exists.

Load Table

The Load Table button is the counterpart to the previous one. You can load a previously saved mapping table.
This command assigns the mapping values to the rows containing values present in the backup. If there are values in the unique values that are not present in the backup, they are kept with the empty fuzzy value.
You can then fill them in to complete the mapping table. If you save the table again, all values will then be present in the backup.

Create fuzzy attribute

This button creates a new field in the source table with the name of the text field and the suffix _fuzzy. The values in this field are the fuzzy values defined in the mapping table for the value of the corresponding source field.

Transformation history

Each time a transformation or aggregation is performed by the plugin, a row is added to a history management table, metafuzzy, which is created and maintained within the data geopackage.

In the case of fuzzy transformations of a text field, the fields filled in are:

  • field: the original field in the layer used for the transformation

  • function: “text”

  • params: the mapping table in text form

  • source1: the name of the source layer of the attribute

  • datecreated

  • username