Forum Discussion
Fuzzy Lookup
One of the most required functionalities in terms of data transformation for Power BI is the ability to do Fuzzy Lookup on two datasets so that input text values with minor errors can still be mapped...
Hi Xiaoxin,
I.know that Power BI does not have this support yet... but for example it is possible to use R to do data transformation correct?
So imagine that in the same dataset I have two columns, one with all values and another that would have only the exact matches... Having this, my idea was to use R to fuzzy match one of the columns with the distinct values of the other one (possible values) and add a third column with the results.
Is this possible?
Thanks
I.know that Power BI does not have this support yet... but for example it is possible to use R to do data transformation correct?
So imagine that in the same dataset I have two columns, one with all values and another that would have only the exact matches... Having this, my idea was to use R to fuzzy match one of the columns with the distinct values of the other one (possible values) and add a third column with the results.
Is this possible?
Thanks
HI Anonymous,
If you meant use r script to deal with original data source, r script support these operations.
I think t-sql fuzzy matching is more simple than r script, you can refer to below links:
Fuzzy Logic function in R as in Matlab
Regards,
Xiaoxin Sheng