topic Re: ArcGIS Pro 2.5: “pivot” tool ends up with incorrect result, in ArcGIS Pro Questions

ArcGIS Pro 2.5: “pivot” tool ends up with incorrect result,

JamalNUMAN — Mon, 22 Jun 2020 19:53:12 GMT

ArcGIS Pro 2.5: “pivot” tool ends up with incorrect result,

I couldn’t figure out why “pivot” tool ends up with incorrect result.

Is this a bug?

In ArcMap, this is successfully performed using the same data (attached)

Re: ArcGIS Pro 2.5: “pivot” tool ends up with incorrect result,

DanPatterson — Mon, 22 Jun 2020 20:29:16 GMT

Looks like a bug, I would zip and ship to Tech Support

Re: ArcGIS Pro 2.5: “pivot” tool ends up with incorrect result,

JamalNUMAN — Tue, 28 Jul 2020 07:59:34 GMT

is this fixed in 2.6?

Re: ArcGIS Pro 2.5: “pivot” tool ends up with incorrect result,

DanPatterson — Tue, 28 Jul 2020 08:52:08 GMT

Release notes for ArcGIS Pro 2.6—ArcGIS Pro | Documentation

You will have to look through the release notes yourself

Re: ArcGIS Pro 2.5: “pivot” tool ends up with incorrect result,

JamalNUMAN — Tue, 28 Jul 2020 16:45:42 GMT

Nothing in the list related to pivot

Re: ArcGIS Pro 2.5: “pivot” tool ends up with incorrect result,

DanPatterson — Tue, 28 Jul 2020 16:47:02 GMT

Maybe it wasn't reported as a bug, so nothing got addressed.

There is always next year

Re: ArcGIS Pro 2.5: “pivot” tool ends up with incorrect result,

Robert_LeClair — Tue, 28 Jul 2020 22:22:15 GMT

Jamal - thank you for providing the gdb.zip file for testing. I was able to get the Pivot Table GP tool to work by adding a new field REF_G2 (as a short integer vs a long integer (what you have). Then I calculated the new REF_G2 using the old REF_G column. From there, I ran the Pivot Table GP tool using the same parameters you have in your screen grab. The result is the same as ArcMap as seen in the image below. Seems the long integer field type is the issue - not sure why.

Re: ArcGIS Pro 2.5: “pivot” tool ends up with incorrect result,

BBicking1 — Wed, 05 Aug 2020 18:01:43 GMT

Hello Jamal,

I repro-ed the issue in 2.7_25974 and logged an issue for it to get fixed.

We had a similar issue in AGPro way back that was data-specific. May be the same in this case.

NOTE: If the fix makes it into a 2.6 patch, I'll let you know.

Thanks for reporting the issue.

Barbara Bicking

Re: ArcGIS Pro 2.5: “pivot” tool ends up with incorrect result,

BBicking1 — Wed, 05 Aug 2020 18:30:30 GMT

Jamal,

a preliminary finding: When Ref_G is the 1st Input Field it works as expected

Please check if that works for you as well.

Still, we will look into the issue.

Re: ArcGIS Pro 2.5: “pivot” tool ends up with incorrect result,

JamalNUMAN — Wed, 05 Aug 2020 19:29:57 GMT

Correct. If the “Ref_G” field is ordered before the “Name” field in the input fields, then the pivot works fine.

In ArcMap, it works anyway. This confirms that this is a bug