How to match exact string with masked string

Question

Hi Colleagues!I need your help to match to columns to being able to compare the price.I have two tables with model and price information, and I need to compare the prices of the models by exact match or similar since I have many masked models.I have already tried fuzzy matching and it does not do it correctly.&nbsp;Here is an example of the data I have.Table 1&nbsp;(with exact models)MODEL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PRICEP3JK4M&nbsp; &nbsp; &nbsp; &nbsp; 50000€P3TO4L&nbsp; &nbsp; &nbsp; &nbsp; 47500€R4TI9P&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;35600€&nbsp;Table 2 (with exact models and masked models)MODEL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PRICEP3J*4*&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45000€P3T***&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45670€R4TI9P&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;32450€&nbsp;The desired result would be to match model P3JK4M with model P3J*4*, P3T*** with P3TO4L and R4TI9P with R4TI9P in order to make a price comparison.&nbsp;Do you think it is possible with Power Query or DAX?Thank you very much in advance!

tahreem24 · Answer

Saray_kh&nbsp;Try to play around with Similarity Threshold value. Range is between 0 to 0.1, it means how strict is your model.
&nbsp;

&nbsp;

saray_kh · Answer

Hi&nbsp;Tahreem24&nbsp;! It doesn't work, the models with * appear as null. I tried to normalize the string replacing the * for a space but it didn't work neither.&nbsp;

Forum Discussion

How to match exact string with masked string

2 Replies

Related content

concatenate strings

Resetting a string pipeline variable

Dynamic String Format

Remove Characters from String which are present elsewhere in the string

exact text string patter test