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.

Anonymous

Not applicable

5 years ago

thank you!! i will test it

in the meanwhile, can you please explain the formula?