Merge and keep rows that don't match

[mmakhlo]

I am attempting to verify URLs from two different tables. I want to verify if the URLs in table A match those in table B and if they don't, display the URL from table B on the visual. I am trying to use the Merge feature but I need it to merge the tables and leave me with the URLs that don't match instead of those that do. Is this possible? If not, any suggestions on how to tackle my problem?

[v-ljerr-msft]

Hi @mmakhlo,

What's the relationship between those two tables(One to One, One to Many, or Many to One)?

Could you post your table structures with some sample data and your expected result, so that we can better assist on this issue? 

Regards

[mmakhlo]

@v-ljerr-msft

This is my current table structure

Site Collections Table

Site Collections Link | Subset 1 Link | Subset 2 Link| Subset 3 Link

Site List

URL Text

These are the relationships I have between the tables. I am connecting each Link column in the left table to the URL Text column in the right table.

The links in the left table may not be accurate as they were entered manually. The link in the URL Text column are accurrate and being constantly updated. What I would like to do is compare them and if they are different for each site replace the wrong link with the correct one. Hopefully that makes sense! Thanks for trying to help!

[v-ljerr-msft]

Hi @mmakhlo,

---

These are the relationships I have between the tables. I am connecting each Link column in the left table to the URL Text column in the right table.

---

If you have linked the two tables with Link column in the left table and the URL Text column in the right table that you want to compare, then you can get the related URL Text for the Link column only when they have the same value. That is to say, if the link in Link column in the left table is different from the link in the URL Text column, then there will be no match value for the link column, then Blank value will be returned.

So you may need to link the two table with other columns(other than the Link column and URL Text column you need to compare). If such columns exists, could you post some sample data, so that we can further assist on this issue?

Regards

[vanessafvg]

When you merge in power query you should have a variety of join options

This article goes through the diff scenarios
https://businessintelligist.com/2015/09/15/power-bi-desktop-merge-query-options/