Azure Data Factory Join Condition is not working

Sarvesh Pandey 71 Reputation points
2022-09-26T07:39:14.133+00:00

Hi All,

There is a Join condition in ADF mapping data flow, and i think there is some issue with it.
Data is not passing through the flow, and this is creating Null records in the Column.

When i performed the join manually in Excel, join condition is working properly. I checked the each record length of the two tables common column and data length is same.

I am not sure why join in ADF is not working but in Excel its showing records. Data file is CSV

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,726 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AnnuKumari-MSFT 31,716 Reputation points Microsoft Employee
    2022-09-26T17:36:43.643+00:00

    Hi @Sarvesh Pandey ,

    Thankyou for using Microsoft Q&A platform and thanks for posting your question here.

    As I understand your issue, you are trying to use join transformation in mapping dataflow, however, it is not working as expected. Please let me know if my understanding is incorrect .

    Kindly make sure the schema has been imported correctly for both the source datasets that you are trying to join . Try importing projection in the source dataset too and check if it works for you.

    In order to provide you better help, Could you please share the screenshot of the join transformation configurations to know what is missing at your end. Also, kindly let us know what are the two source datasets in your case for joining. Looking forward to your response. Thanks !