topic ArcGIS Pro 3.3.2 query in ArcGIS Pro Questions

ArcGIS Pro 3.3.2 query

MarzenaChojnacka — Thu, 24 Oct 2024 19:13:05 GMT

Hello, I created a query to compare two datasets:

MAX_BRK_RATE <> RATE_MAX

I want to select records in the Max_Brk_Rate that don't match the Rate_Max records. The result returned with records that did not match but also some records that matched. Any idea why the matching records would show?

Thank you

Marzena

Re: ArcGIS Pro 3.3.2 query

Robert_LeClair — Thu, 24 Oct 2024 20:10:07 GMT

@MarzenaChojnacka - without knowing much about the data, it's kind of difficult to troubleshoot this error. If possible, can you share the data with me? My email address is rleclair at esri dot com - thanks!

Re: ArcGIS Pro 3.3.2 query

Eugene_Adkins — Fri, 25 Oct 2024 13:10:12 GMT

As @Robert_LeClair mentioned, it's difficult to say without seeing it, but one idea (if domains are not being used to create the records) is spaces after the entered data which would cause the appearance of a match to the eye but informationally there would be a mismatch due to the added space(s) at the end.

Re: ArcGIS Pro 3.3.2 query

MarzenaChojnacka — Wed, 30 Oct 2024 14:09:48 GMT

I can't change the data type in my table. Following a suggestion, I tried to apply a script, but it didn't work. Do you have any thoughts on why it didn't work or what I can try to round the field to two or three decimal places?

Re: ArcGIS Pro 3.3.2 query

JoshuaBixby — Wed, 30 Oct 2024 21:02:28 GMT

Can you share a stripped down sample of data that exhibits the behavior?