If column x in table 1 starts with column y in table 2, return value in column z in table 2

[benryon1]

I have two tables. In Table 1 is a list of URLs from a website, with page views and date. Table 2 is a category table that has the beginning of URL's that map to various categories.

I want to create an old fashioned vlookup with a text.beginswith to return Column Z from Table 2 as a new custom column in Table 1, utilizing Column X (full URL) and Column Y (beginning of URL). 

How the blue devil do I do this? Is it possible? Or is it so simple I'm missing something?

Table 1

Date	URL (Column X)	Page Views	New Column (Column Z)
1/1/2019	www.xxxx.com/zzzz/3454545	1,233	Category 1
1/1/2019	www.xxxx.com/qq/rrr/34546666	3,444	Category 2
1/2/2019	www.aaaa.com/ooo/iii/34345455	1,222	Category 3
1/2/2019	www.xxxx.com/zzzz/ereree	33,444	Category 1

Table 2

URL (Column Y)	Category (Column Z)
www.xxxx.com/zzzz/	Category 1
www.xxxx.com/qq/	Category 2
www.aaaa.com/ooo/iii/	Category 3

[SteveCampbell · Accepted solution]

1. open power query
2. duplicate the URL URL (Column X) in Table 1
3. On the Home table select  >  Split Column > Split by Delimiter
4.  
5. 
6. this wll give you a new column with the base url and some junk after it - you can delete that one
7. Join table 2 to table 1 on the new column x and URL (Column Y) 

[benryon1]

I was thinking that before, but the URL structure is different for many different URLs. Instead of working from the end, I was hoping ot match certain values from the beginning. 

Some URLs:

• www.xxx.com/xxx/xx/xx/3434343
• www.xxx.com/xxx/34343434
• www.xxx.com/xxx/xx/343434343

Not sure if this makes sense? 

[SteveCampbell]

This is what produces from my answer

URL (Column x).1 (highlighted) would match in the original table, you can delete .2

Otherwise you could start from left and just get the base

If not maybe I do not understand what would be needed

[benryon1]

No, actually, this works afterall. Thanks for sharing!