Forum Discussion
Power Query merge Issues
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
Power Query is case-sensitive. Doesn't that explain this?
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
4 Replies
Power Query is case-sensitive. Doesn't that explain this?
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?
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.
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