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

Forum Discussion

Match Wildcard via Relationship or Merge

Related content

Relationship

Use Wildcard Operator

Relationships

Relationship Issue

Creating relationships