Community

2025 BA Demo Dataset custom field names

124
1
3 weeks ago
Labels (1)
LoriHatfield1
by
Occasional Contributor
3 weeks ago

Hi - I have a few Business Analyst custom reports that I download to Stripped XLSX format and then use several macros to format the data in Excel.  I noticed with the 2025 BA data (ArcPRO), custom fields are now downloaded not using the Field Name/Alias but a GUID. Up until the 2025 BA data, I had been running all my demo reports in ArcMap.

My question is will the GUIDs remain the same across different BA reports?  For instance, I have several income fields as follows:

HH_INC_75KPLUSCUSTOMED21DB7243D8465AACD4147F7AB1BCEA
HH_INC_100KPLUSCUSTOM9F5F075ADD724D5B97978997C2BE7FA9
HHINC_150KPLUSCUSTOMB5443DFC61174CFBBE17D5308F6EE673

I use these same custom fields in a drivetime report, trade area report and  radius report.  Right now my macro is looking for the HH_INC_XXXX field name, if I change it to the respective GUID will that remain constant like my field name did - even if I add or delete a variable?  I typically run a large number of stores at a time which is the reason the macro is needed to parse the demographic data by store.

Thanks for any guidance or direction that you can provide. This is new for me as I typically am used to seeing the field names so I was a bit taken aback at first when I downloaded the data.

0 Kudos
1 Reply
CherylHagevik
by Esri Contributor
Esri Contributor
3 weeks ago

Hi @LoriHatfield1 Thanks for reaching out with your question. When adding a custom variable to infographic and report templates, the GUID for the custom id is assigned when you add the variable to a template. If you would like the id to remain the same between different templates and are using the same panel/element, you can use the option to Add panels from another template, then the id will carry over to the new template. 

CherylHagevik_0-1758242598089.png

 

If you are not using the same panel/element between templates and need to add the variable in a different design format, then it would receive a new id. You could work around this by manually editing the ids in the metadata of the template. Please let me  know if you would like to learn more about this manual editing method. However, please keep in mind editing the files directly would be a workflow you could perform at your own risk. Hope this helps!

 

0 Kudos