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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

rds_2019  what is the purpose of joining?

If you just want to relate them you can create an index coumn in each table and then relate them. If not you like to compare and match data values between tables, you can use Calculate and firstnotblank. If you don't know how to use them let me know to make and example.

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.