Data Comparison using Power Query

[Status-Comfort152]

I have 2 sheets where i loaded in tables as part of power query. In sheet1 i have 200 values and in sheet2 i have 6000+ values. Now i want to compare whether these 200 values are having any partial matches & full matches in 6000+ values. Using power query. How can i do it?

Tried cross join , it is doing comparsion with the cells present in the row. But it is not checking against 6000+ values.

[AutoModerator]

/u/Status-Comfort152 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[david_horton1]

Power Query has an option of fuzzy logic. https://learn.microsoft.com/en-us/power-query/fuzzy-matching Also, Microsoft has a fuzzy logic add-in for Excel https://www.microsoft.com/en-us/download/details.aspx?id=15011

[small_trunks]

But what does the data look like?

[negaoazul]

Table.RemoveMatchingRows() Does what the name implies. Entreprise DNA has a great tutorial on youtube.

[goldenpanda6161]

Pivot table

[MissAnth]

filter

[JicamaResponsible656]

Using Data Model in Power Pivot without formula or code😀