topic Re: Append Data in ArcGIS Business Analyst Questions

Append Data

BrandonPowell1 — Tue, 30 Oct 2018 19:45:54 GMT

Hey All,

I'm trying to append data to a "whole layer." I created a trade area using standard geographies that includes 8 zip codes. The attribute table of that trade area has 8 rows of data, 1 for each zip.

When I use append data to add some demographic variables and then finish, it creates a new layer with 8 rows of data + the appended data as expected.

My question is this: Is there a way for that data to be aggregated together? I need the 8 zip codes, which all touch each other, to be treated more like a whole layer trade area, so that if I'm appending population, for instance, I'll get the population of that whole trade area instead of the population per 8 zip codes. thanks for any help!

Re: Append Data

KyleWatson — Wed, 07 Nov 2018 18:22:37 GMT

Hi Brandon - have you tried to Dissolve the 8 boundaries into one whole boundary first? We do this for Business Analyst Reports within that workflow, but you can use the Dissolve GP tool before running Data Append.

Here's a Help link:

Dissolve—Help | ArcGIS for Desktop

Re: Append Data

BrandonPowell1 — Fri, 09 Nov 2018 15:56:14 GMT

Thanks for the tip Kyle! I've never used the dissolve gp tool, but will give it a go next time. I ended up creating a BA study area so that all the zips were one whole boundary and it worked for me.

Re: Append Data

KyleWatson — Mon, 12 Nov 2018 14:38:29 GMT

You bet. Creating a Study Area will certainly work, and actually behind-the-scenes that tool uses Dissolve to merge multiple boundaries together as one. However when using a Study Area you will limit your analysis to only that boundary when it is set to active. Try out Dissolve - it's fun!