Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello World,
I have this 2 Excel file.
1. Final Dataset
2. Lookup Dataset
I want to merge 2 columns from Lookup dataset to my final dataset file. I want to bring transaction date from lookup dataset to my final dataset. I got agrrement number in both my dataset.
I went to transform data, merge queries (Selected Final Dataset) as new. Then I selected my Lookup dataset and did Left Outer Join. I selected agreement number for matching column. The selection matches 67654 of 107078. I hit ok. I then brought the transaction date in the merged dataset.
But the problem now is, in merged dataset, the count of row is 392,681.
When my Final dataset actually just have 107,078 rows.
Now the merging doesn't makes sense. It's giving me all wrong analysis.
Hi @Timbuktu7 ,
Please check the lookup file in case it has multiple rows for the same join key.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos!