Fuzzy Field Querying/Filtering

During fuzzy querying and filtering, which differs from exact querying, the querying system automatically retrieves text fields to obtain values within a certain range based on the entered keywords.

The fuzzy query is similar to the Like operator in SparkSQL statements.

FineDataLink makes fuzzy querying and filtering easier by visualizing the process, thus improving efficiency.

Contain/Not Contain

Click Add Condition (AND) and select the Number field.

• Contain: filters all values that contain 1234 in the Number field, as shown in the following figure.

The filtering condition is equivalent to the Spark SQL statement:

select * FROM DB_table_input WHERE `Number` like '%1234%'

The result is shown in the following figure.

• Not Contain: filters all values that do not contain 1234 in the Number field, as shown in the following figure.

Begin With/Not Begin With

• Begin With: filters all values that begin with 12 in the Number field, as shown in the following figure.

• Not Begin With: filters all values that do not begin with 12 in the Number field, as shown in the following figure.

End With/Not End With

• End With: filters all values that end with 34 in the Number field, as shown in the following figure.

• Not End With: filters all values that do not end with 34 in the Number field, as shown in the following figure.