Forum Discussion

Moniek's avatar
Moniek
Resolver I
3 years ago
Solved

Search another table

Hi,    I have a table (TableA) with many many rows and many columns, one column is named Despriction. In another table (TableB) are serveral rows with a part of some discriptions. I want to know in...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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 _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Moniek's avatar
    Moniek
    3 years ago

    Super!!!! Thanks!!!!

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

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 _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Moniek's avatar
Moniek
Resolver I
3 years ago

Super!!!! Thanks!!!!