Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

join in dataflow

after joining file1 and file2, I can see three rows The first few rows belong to file1. At the end of the result table I see a column named as file2.xlsx [Table] and if I click on it it expands and ...
Dataflows
  • v-cboorla-msft's avatar
    v-cboorla-msft
    2 years ago

    Hi Anonymous 

     

    Thanks for using Microsoft Fabric Community.

    I tried to repro the scenario, I took File1 and File2 with the following data.

    File1:

    File 2:

    Even I am able to see the list of columns in File2 when I expand the column named as File2, below is the screenshot. 

    Note : Here I have used "inner join"

    After clicking ok button, I am able to see total 5 columns since I have 2 extra columns with different values.

    When I click on the [Table] for first row, this is the output.

     

    When I click on the [Table] for second row, I got 2 rows because I have 2 different values for the same Customer ID column.

    Even I tried to replicate the same scenario in SQL editor got the same output, Please find the screenshot for reference.

    If the issue still persists, could you please share more details of your source, so that I can guide you in better way.

     

    I hope this information helps.

     

    Thank you.

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi Anonymous 

 

Thanks for using Microsoft Fabric Community.

I tried to repro the scenario, I took File1 and File2 with the following data.

File1:

File 2:

Even I am able to see the list of columns in File2 when I expand the column named as File2, below is the screenshot. 

Note : Here I have used "inner join"

After clicking ok button, I am able to see total 5 columns since I have 2 extra columns with different values.

When I click on the [Table] for first row, this is the output.

 

When I click on the [Table] for second row, I got 2 rows because I have 2 different values for the same Customer ID column.

Even I tried to replicate the same scenario in SQL editor got the same output, Please find the screenshot for reference.

If the issue still persists, could you please share more details of your source, so that I can guide you in better way.

 

I hope this information helps.

 

Thank you.

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi Anonymous 

     

    Glad that you query got resolved.
    Please continue using Fabric Community for further queries.

     

    Thanks.