Forum Discussion
Need correction in M query to join two tables based on pattern
Hi All, I want to join two tables to get the result using a pattern table in the Power query. This is my source table with Publisher, version, and tech name values. and I want to join the jo...
Hi Pbi_newuser2994 ,
You could first split the 'tech name should not contains' then unpivot the columns of splitted.
Then merge two table to match the values.
Please refer to
Power Query - Matching a value from a list using power Query - Microsoft Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous Thanks for your reply. I can understand your solution but I'm permitted 1 row for 1 pattern.
Is there any other way we split and use it in a single cell?