Forum Discussion
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 ...
it worked but not performing well on my data (~3K rows)
do you have any other idea?
camargos88
Community Champion
Community ChampionAnonymous ,
Can you share your pbix ? Masking any sensitive info if necessary.
- the data is sensitive and therefore i cant share it with you
- camargos88
Anonymous ,
How long is it taking to process this new column ?
table a ~9K rows
table b ~8K rows
its took more than 3 hours