I'm new to Power Query, so need some help. My table is rather large, 6 columns and >159,000 rows, and I can see multile versions of a name entered by users. For example Berk, G Berk, Dr Berk or Dr. Berk. I need to make sure I get all data associated with each version of the name. When I search the table for "berk", I find all examples. When I load the table into PQ, I cannot see the different versions of the name as I would expect to see them in PQ. At the bottom of the PQ window I see a note that the list may be incomplete. It seems there is an incomplete loading of the table.
The question I have is how will I know when the PQ download has been completed and what does the message regarding the incomplete list mean? Why am I not seeing all versions of the name entered by multiple users?
Thank you for your help.
Hi Rod,
Power Query only loads a preview of your data in the Query Editor. This helps it remain responsive while you're editing and transforming the data. If you need to load more of a field you click on the link in the Filter drop down beside the warning that your list may not be complete. If you have 1000's of unique items then it may not show all of them in the preview.
When you 'Close & Load' the data it loads all of it, not just that shown in the preview.
Mynda
Mynda; Thanks! that helps.
My second question is that I have names of Dr's entered by patients into a database in an inconsistent manner. As in my first post it could be Berk, Dr Berk, Dr. Berk or G Berk. You get the idea. In a table of the data I can filter for berk and they all show up. This gives me a list of patient identifiers. The patient identifiers are in a separate column. How can I use the list generated by berk to then select out all the patients associated with the physician. I can print out a list but I then have to select the patients by their identifiers in their column manually but this is laborious and error prone. It seems like I should be able to combine the searches and generate a list of all the patients with their data using PQ. I'm doing something wrong.
Thanks for the great video's and help.
Hi Rod,
I'm confused by this sentence: "I can print out a list but I then have to select the patients by their identifiers in their column manually but this is laborious and error prone."
If you've already filtered your list of Doctors for Text Containing 'Berk' then don't you have your list of patients? What is the ideal location for this list? Do you want it in a worksheet?
If you can provide a sample Excel file with your data and ideal output then we can help you further.
Mynda
