Finding similar instances in your data
Query builder offers the option to find similarities to a known data entry within the data source and also an ad-hoc option where the instance to be compared so is outside of the data set.
Similarity Search options
Selecting the Similarity Search from the Query Builder screen will prompt you to select which type of search you would like to perform.
Option 1- Existing
This allows you to find similar items to an ID that you provide which ALREADY exists in the data set
Option 2 - Ad-hoc
This allows you to provide an external item to find similarities to within the data set
Existing data search
- Enter the number of similar items you would like to retrieve
- Enter the reference to the item to search for (in this case a fashion post/id)
- Select the level of detail to return (The second adds in a field for the queried item)
- Click on CREATE QUERY
The required SQL query will be generated and you will be presented with this within the SQL screen.
The Query can now be executed
Ad hoc search
Selecting ad-hoc search allows you to add in an external item to find similar items for.
- Enter in the number of items to return
- Add in the item to be compared against
- Click CREATE QUERY
The created query will be generated...
The Query can now be executed