Forum Discussion
Merging in Power Query
Merge always gives me a headache.
Situation is:
I have a table of opportunities with an Opportunity ID. I have another table, called Quotes, that contains the Opportunity ID as well...but also has the column I need in my Opportunity table, which is, the Order number from our ERP table.
I thought by merging the tables, using the Opportunity ID with a Left Outer join would give me all my Opportunities in my current table, but then bring in just the Order number from the SF quote table. I essentially want to match the Opportunity ID from both tables, so that for those Opportunities that have been coverted, the Order number will show up in the new column.
But in doing so I went from 9600 rows in my Opportunity table, to 23000. Is it possibly a granularity issue?
have you checked the rowcounts on both tables? Is it not possible that a customer has more than one quote but then i suppose the opportunity id would be different? If not check for duplications. What are you joining on? best to share some of the data.
3 Replies
- vanessafvg
Community Champion
have you checked the rowcounts on both tables? Is it not possible that a customer has more than one quote but then i suppose the opportunity id would be different? If not check for duplications. What are you joining on? best to share some of the data.
Hi Anonymous,
How about use relationship mapping two tables instead of directly merge these tables in the query editor?
For this scenario, you can extract two table id field values and use them to create a bridge table with unique keys to link two tables.
How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive
Regards,
Xiaoxin Sheng
HI Anonymous,
Any update for these? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng