View Single Post
Old 12-13-2019, 09:48 AM   #260
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Similarity Queries

Quote:
Originally Posted by Tanjamuse View Post
Thanks a lot. Could it perhaps be expanded so that it's more than just one column? Also what's the percentage for find duplicate's "similar" ?

[1] The unique similarity group ID custom column is tag-like, so there only needs to be one (1) of it. To compare multiple columns for each book, simply execute the query for each column sequentially. The image shows that many queries for different comparison value columns have already been executed, with the many unique similarity group IDs for each book, if any, so indicated.


[2] The Value Comparison Percentage specifies how similar a comparison value has to be for one book to another book for a specific comparison value from the specified comparison value column. 100% means "identical".


Attached is an example that includes the Debug Log.




DaltonST
Attached Thumbnails
Click image for larger version

Name:	mcs_similarity_query_example.jpg
Views:	255
Size:	545.7 KB
ID:	175574  
DaltonST is offline   Reply With Quote