join in dataflow

[Anonymous]

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 shows the columns in file2.

When I click on [Table] value in the column, then I get 7 rows - 3 rows from file1. 4 rows from file2

I expect to see only 3 rows even when I expand the column.

Any suggestions?

Thank you

[v-cboorla-msft · Accepted solution]

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]

Hi @Anonymous 

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

Thanks.