I am trying to merge two tables to get 3 columns from the other table and it is creating 4 additional duplicate rows (in the actual report, which has led to more than 2 million rows). I have created a sample here and it even did the same thing to that. I was wondering if somebody could help me out here. I am doing a left outer join and have made sure that the tables do not have duplicates beforehand.
I am attaching screenshots of my sample file here,
Attendance Table:Classes Table:
Hi @syasmin25 ,
Are you merging them with unique id's per row ?
If not they are gonna replicate the rows from the outer table.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.