Forum Discussion
Resolver ISearch another table
Hi Moniek ,
In the merge step, there is an option "Fuzzy matching options", expand the option, you can set the similarity threshold, which controls how many words the two values are matching, the defalt value is 0.8, you can reset it based on the fact data. Here I reset it to 0.5, then the "gele banana" matchs "banana".
There still a option "Ignore case", select it to ignore case when match.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super!!!! Thanks!!!!
Community SupportHi Moniek ,
According to your description, here's my solution. I create a sample to clarify.
TableA:
TableB:
1. If the values are exactly match, you can use List.Contains function. Create a custom column.
if List.Contains(TableA[Description],[Description]) then true else false
2. If the values are partially match, you can merge queries.
Select the option "Use fuzzy matching to perform the merge".
Then the partially matched values are filtered out. You can do further calculation based on the column.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Resolver IThanks, this is a part of the solution, this solution does not regocnise when the search desciption contains a part of the discripton. In my example, "gele banaan".
And uppercase letters. Is there somthing you can add it in the Custom coloumn?
- v-yanjiang-msft
Hi Moniek ,
In the merge step, there is an option "Fuzzy matching options", expand the option, you can set the similarity threshold, which controls how many words the two values are matching, the defalt value is 0.8, you can reset it based on the fact data. Here I reset it to 0.5, then the "gele banana" matchs "banana".
There still a option "Ignore case", select it to ignore case when match.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Moniek
Super!!!! Thanks!!!!