Forum Discussion

Anonymous

Not applicable

5 years ago

like operator as join condition between tables

hi, i want to join (inner) between table A to B based on LIKE opeartor logic: ON A.Column LIKE '%' + B.Column+ '%' example: XXXXXX8074396XXXXXXX LIKE '%' + 8074396+ '%' ----> there is a much ...

Icon for Community Champion rank

Community Champion

5 years ago

Hi Anonymous ,

Try creating a column like this:

let _phrase = [Column1] in

List.Select(Item[Item], 
each Text.Contains(_phrase, Number.ToText(_))
)

Also, see the attached file for more info.

liorro.pbix24 KB

Anonymous
Not applicable
5 years ago
thank you!! i will test it
in the meanwhile, can you please explain the formula?
Anonymous
Not applicable
5 years ago
it worked but not performing well on my data (~3K rows)
do you have any other idea?
- camargos88
  Community Champion
  5 years ago
  Anonymous ,
  
  Can you share your pbix ? Masking any sensitive info if necessary.
  - Anonymous
    Not applicable
    5 years ago
    the data is sensitive and therefore i cant share it with you