Forum Discussion

ABR002's avatar
ABR002
Icon for Helper I rankHelper I
2 years ago
Solved

Match Wildcard via Relationship or Merge

So I've found some topics on this subject but none seem to pertain to my exact situation. I have 2 tables with codes in ABC-####-##### format. On one there is only one value per cell, but on the othe...
Need Help
  • Omid_Motamedise's avatar
    Omid_Motamedise
    2 years ago

    Consider this table as your second table in power query.



    select column code and go to transform tab and pick split column by delimiter and use "," as delimiter to reach the next table

     

     

    now right click on the column row number table 2 and pick unpivot other columns to reach the next table

     

     

     

    you do not need column attribute, by reming this, you reached a tablel apporopriate for merging by the first om

Omid_Motamedise's avatar
Omid_Motamedise
Icon for Super User rankSuper User
2 years ago

Consider this table as your second table in power query.



select column code and go to transform tab and pick split column by delimiter and use "," as delimiter to reach the next table

 

 

now right click on the column row number table 2 and pick unpivot other columns to reach the next table

 

 

 

you do not need column attribute, by reming this, you reached a tablel apporopriate for merging by the first om