How to get data from two unrelated tables with partial search

[Anonymous]

Hello Everyone,
I hope somebody can help me with this.
I have two tables which don't have relationship ,But I want to create a new column in "table 1" with partial search of using column "units" from "table 2",I was trying using dax function but not able to get suceeded in that,one more tricy thing is there first come first server should be mapping from "table 2" column units ,So below I am sharing the example  

table 1:-                                                                

tags

rohit,Devps,Devps/Amer/Ser,Lin,Ser

rj,vps,vps/mer/er,in,er

Devps,Devps/Amer/Ser,Lin,Ser

vps,vps/mer/er,in,er

 table2:- 

units	form
,rohit,	Global
,Devps,	Global
,rj,	Global
,vps,	Global

output:-
table 1:

tags	unit	form
rohit,Devps,Devps/Amer/Ser,Lin,Ser	rohit	Global
rj,vps,vps/mer/er,in,er	rj	Global
Devps,Devps/Amer/Ser,Lin,Ser	Devps	Global
vps,vps/mer/er,in,er	vps	Global

Please, somebody help me with this!

Thanks in advance.

[v-zhangti · Accepted solution]

Hi, @Anonymous 

Both Table 1 and Table 2 require Split Column in power query.

Table1:

tags = [tags.1]&","&[tags.2]&","&[tags.3]&[tags.4]&","&[tags.5]

Table2:

Delete the blank lines after the split. Establish a direct relationship between the 2 tables.

This gives you the output you expect.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mh2587]

Like this ?

[Anonymous]

yes like this only