topic Issue with JMP Query Builder results in Discussions

Issue with JMP Query Builder results

tjcraneUMN — Thu, 03 Aug 2023 22:37:59 GMT

I am having an issue with the results from the JMP Query Builder.

I generally use Microsoft Access to do queries, but my dataset is so big (13,148,520 rows) that my IT dept. suggested I try JMP Pro.

I have two tables that I am linking on the "Covered_Recipient_Profile_ID" field:

I am doing a left join on the "JMP table with AHC NPI 2AUG23" table

Here is my Query Preview:

This query runs and returns SOME of the rows from the OP_DTL_GNRL_PGYR2022_P06302023 table, but it is not returning ALL the rows.

Any ideas what I am doing wrong here or how I can make sure all the matching rows are included?

Re: Issue with JMP Query Builder results

Phil_Kay — Thu, 10 Aug 2023 11:47:39 GMT

It's not obvious that you have done anything wrong in JMP Query Builder. It sounds like a relatively simple query. Did you ask for a sample rather than all data (that is an option in Query Builder)? And, of course, the Query Builder interface will only show you a sample of rows initially, you only get the whole lot when you hit Run Query.

I wonder if this is just a lot of data to pull and this is causing problems on the database end. You might need to talk with your IT/ DB Manager. Like I say, the JMP side of things here is simple, so it feels like the problem would be elsewhere.

I hope this helps,

Phil

Re: Issue with JMP Query Builder results

tjcraneUMN — Thu, 10 Aug 2023 12:46:10 GMT

Thanks for your response! I do believe it is an issue with the data in that particular field in the massive table. I was able to link the two tables using a different field and my query worked just fine.

Re: Issue with JMP Query Builder results

Phil_Kay — Thu, 10 Aug 2023 15:49:21 GMT

Thanks for letting us know. I hope you find Query Builder useful. It is a phenomenal tool that not many people know about.

Re: Issue with JMP Query Builder results

tjcraneUMN — Thu, 10 Aug 2023 15:54:12 GMT

I am really enjoying learning how to use it. I am not a statistician, but I have found the Query Builder to be very helpful.