Forum Discussion

rds_2019's avatar
rds_2019
Icon for Helper I rankHelper I
7 years ago
Solved

Join 2 tables by using LIKE or containstring

Hi, Is it posible to join 2 tables using LIKE instead of equal.   So if there are 2 tables tables1 and table 2 and join is on column1 and column11 respectively. So can we use something like   W...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi rds_2019 ,

    You can try to use the function of SEARCH to find the keyword. Is there any column in your table that can link two tables? I created a sample using the function of  RELATED to combine two columns based on id. 

    Column = IF(SEARCH("*efg*",'Table 1'[Column1]),RELATED('Table 2'[Column1]),BLANK())

    Best Regards,

    Xue

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

rds_2019's avatar
rds_2019
Icon for Helper I rankHelper I
7 years ago

Thanks for replying. My purpose is of relating or joining 2 tables so that i can use one table's values in anoher .

So in Table1.column1 has value =

 

Column1
efg

and table2.column2 has values = 

 

Column2Column3
efgrr
efgttmm

 

I want to make sure when i design report for table1. it considers both values of table2.Column3..

Currently since join is between efg and efg.. column3's value "rr" will be considered .

I want both rr and mm of column3 should get considered in the report against value efg of table1.column1.

 

I hope i made sense to you.

 

Cheers,

RDS

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi rds_2019 ,

You can try to use the function of SEARCH to find the keyword. Is there any column in your table that can link two tables? I created a sample using the function of  RELATED to combine two columns based on id. 

Column = IF(SEARCH("*efg*",'Table 1'[Column1]),RELATED('Table 2'[Column1]),BLANK())

Best Regards,

Xue

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