Forum Discussion

EvertonRosa's avatar
EvertonRosa
Icon for Helper I rankHelper I
5 years ago

Data Mining table from List of Values

Hi ALL   I need a little help.   Is it possible to use Power BI to data mining? Let me explain my case.   I have a project where i have a table "dProducts" with produtc name, product code, prod...
Need Help
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

Hi EvertonRosa ,

To search columns in Power Query, you can use Merge feature, please refer:

Tutorial: Shape and combine data in Power BI Desktop 

 

Since there is no matched results based on NCM columns from your sample, currently it would return a blank table. 

For fuzzy merge to create a column, please refer this blog:

How to fuzzy match the dirty data and horizontal display the corresponding table 

 

Reference function in Power Query: Table.AddFuzzyClusterColumn 

 

Best Regards,
Community Support Team _ Yingjie Li

  • EvertonRosa's avatar
    EvertonRosa
    Icon for Helper I rankHelper I
    5 years ago

    Thanks v-yingjl 

    I am trying a different approach, cause in some cases result will be only text similarity. 

    NCM is onlyne first step validation.