column match -- join

Question

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

Answer 1

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!