Power Query merge Issues

[Julier]

I am merging from 2 tables however the merge only brings through the first find and then stops, i have trimmed and cleaned the data and check that it is nt hte capitals that is stoppping it from working  on both tables and checked in excel that the data is the same.

This is the table with the merge as you can see it has stopped after it has found the first set of data

This is the table i need to lookup from and bring back the asset group but it stops once it has found Corrugator

 

[HotChilli · Accepted solution]

Power Query is case-sensitive.  Doesn't that explain this?

[HotChilli]

OK, you have all the tools to investigate this.

Try a Group By and see if the suspected same entries are shown in 2 groups.

OR

remove all the entries apart from the suspected non-matching entries. Look at the Column quality, distribution and profile features.

OR

remove all the text apart from the first 3 characters. Do the merge. See if it works. If it does, use 4 characters to merge, repeat until it breaks.

[Julier · Accepted solution]

Thanks for this, the case sensitive did work, the problem was that the 2 tables had a mixture of upper and lowercase rows, once i had amended the two files to read the same it worked

[Julier]

thank you but no it doesnt, i have changed the Site ID_Asset ID to uppercase and it still does not pull the data through?

[HotChilli · Accepted solution]

Power Query is case-sensitive.  Doesn't that explain this?