In power query (or MS query, or really anything else that would create a refresh-able table that gives me the desired results in excel), how can I join on partial matches between two fields?
I want to do something similar to this SQL statement:
SELECT T1.SIZES AS SIZES, T2.PARTNO as PARTNO FROM TABLE1 AS T1 LEFT JOIN TABLE2 AS T2 ON T2.APPLICATIONS LIKE '% ' T1.SIZES ' %'
For example: say I have
TABLE1 which has the following data in field
And I have
TABLE2, which has the following data in fields
PART NO and
I want to do a left outer join of TABLE 1 on TABLE2, and return any rows which have a partial match between
The results would be the following:
- SIZES___________PART NO
I tried to follow along this example of implementing a like function in power query, and was able to create the formula, but can't figure out how to use it as criteria for a "query merge" (join).
I'm a total novice in power query...