Map Fuzzy Matching

Version

Application Scenario

Sometimes the area names in your data are inconsistent with the area names in the built-in map in FineReport. The mismatch will make the data fail to display correctly in the frontend display of the map.

The fuzzy matching function can solve the mismatch problem of the area names.

For example, if the area name in the built-in map is Anhui Province while the corresponding name in your data is Wan (the abbreviation of Anhui province), you can match Wan with Anhui Province through fuzzy matching for frontend display, as shown in the following figure.

Function Description

Application Scope

The fuzzy matching function is applicable to area maps, point maps, flow maps, combination maps, drill area maps, drill point maps, custom drill maps, and heat maps.

Matching Rules

The abbreviation of the area can be matched with the built-in area name. For example, Wan can be matched with Anhui Province.

The short name of the area can be matched with the built-in area name. For example, Jiangsu can be matched with Jiangsu Province and Nanjing can be matched with Nanjing City.

The detailed area name can be matched with the built-in area name. For example, Nanjing City, Jiangsu Province can be matched with Nanjing City.

Currently, the areas with the same names cannot be fully matched with the built-in areas. For example, both Nanjing City and Kaifeng City have Gulou District which cannot be matched with the built-in area name correctly. In this case, you need to manually match the areas (with the same names) with the corresponding built-in areas.

The following content introduces the configuration method for map fuzzy matching in detail, with the area map as an example.

Function Entry

1. Click Data on the right attribute panel, and click  icon on the right side to bring up the setting page of area name matching.

2. The following figure shows the setting page of area name matching.

Dataset: You can select the template dataset or the server dataset as Dataset, while the cell data cannot be selected.

Area Name: The field of the area name in the dataset.

Refresh icon: When the matched relationships or data change, you can click the icon  to view the latest matching list.

Default match list: After you set the dataset and area names, the area names will automatically match to the built-in area names in a fuzzy way, and the default relationship will be displayed in the middle area.

Custom Match List: You can select the built-in area name from the drop-down list of the Match to column, or manually enter the built-in area name to customize the matching relationship between the area names. The customized relationships are displayed in the custom match list.

Note:

1. In the match lists, the area names of the dataset are displayed on the left, and the built-in area names are displayed on the right.

2. When the default matching is incorrect, or the matching cannot be performed, you can use the custom matching function to select the matched item manually.

3. When using the fuzzy matching function in the drill map and Basic Data Summary is selected in Data for the map, you only need to set the matching relationship for the bottom level.

Built-in Matched Item

1. The area name of the matched item (shown in the following figure) varies with the set map boundary, and you can select an appropriate map boundary according to the area name in the dataset.

2. The following figure shows the setting method of the map boundary.

3. The following table shows the relationship between the map boundary and the matched item.

Default Matching

After you set the dataset and area names, the area names will automatically match to the built-in area names in a fuzzy way.

When Select a matched item in read highlighted font is displayed in the Match To column on the right, which means the corresponding name on the left cannot be matched automatically, you need to change the map boundary or customize the matching relationship.

Custom Matching

When the default matching is incorrect, or the matching cannot be performed, you can use the custom matching function.

1. Custom Matching Method

You can search the area name in the edit box, or select the built-in area name from the drop-down list of the Match to column on the right to customize the matching relationship, as shown in the following figure.

2. None as Custom Matched Item

When you select None as a matched item, as shown in the following figure.

The corresponding area is grayed out with no data when the map is displayed, as shown in the following figure.