column match -- join

arkiboys 9,686 Reputation points
2024-04-22T07:22:36.67+00:00

hello,

In ADF dataflow join condition,
table1.portname = 'exeter'

table2.portname = 'las exeter'

How can I indicate in the join condition between these two fields that the above two values does indeed present a match? If I use == then there is no match because one has the word 'las' and the other does not.

thank you

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
0 comments No comments
{count} votes

Accepted answer
  1. Patchfox 3,811 Reputation points
    2024-04-22T07:33:16.9766667+00:00

    Hi arkiboys I want to help you with this question.

    To verify your question, you want to know how ADF can indicate matchings of two values in different tables in a join condition, correct?

    I would do the following:

    Custom Cross Join: In your data flow, use the Join transformation to combine data from table1 and table2. Choose the Custom cross join option. Specify a custom expression for the join condition. Instead of using the equality operator (==), you can create a custom expression that accounts for the difference in the values. For example, you can use the following expression:

    CONTAINS(table2.portname, 'exeter')
    

    This expression checks if the value in table2.portname contains the substring 'exeter'.I hope this will help you to answer your questions.


    If the reply was helpful, please don’t forget to upvote or accept it as an answer, thank you!

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful