topic Re: Multiple Rows merging in Data Management Questions

Multiple Rows merging

MarcusHumphrey — Wed, 20 Aug 2014 11:41:29 GMT

I have multiple rows that on a feature class, with lots of repeats in it, but showing different data, and want to find a way in which this could be merged to make a chart? Has anyone any help? I only have ArcView.

Re: Multiple Rows merging

NeilAyres — Wed, 20 Aug 2014 12:55:07 GMT

A little bit more detail here please. Perhaps an example of your data and what you want to achieve.

I have just checked but tools like the "Pivot table" tool is at an advanced level.

Might need to do something with python, or export the data to excel to get to where you need to be.

Neil

Re: Multiple Rows merging

XanderBakker — Wed, 20 Aug 2014 12:56:02 GMT

It might help if you post a sample of your data and explain in more detail what type of chart you want to create and what need to be done with the "repeats" (redundancy) in the data.

Also include the version of the software you´re using.

Kind regards, Xander

Re: Multiple Rows merging

MarcusHumphrey — Wed, 20 Aug 2014 13:07:35 GMT

not posting data due to what the data is on.

data came from excel and had to do a spatial join and select on it.

ArcGIS 10.0

Looking to produce a chart with stacks on showing different depth levels, these depths are currently stored in seperate rows for each feature, there is multiple features in the table. Trying to find a way to get all the depths to show per feature.

Re: Multiple Rows merging

MarcusHumphrey — Wed, 20 Aug 2014 13:47:59 GMT

Have looked at pivot table, and looks like it does what I need, do you knoww of anything that'll do the same as pivot table?

Re: Multiple Rows merging

MarcusHumphrey — Wed, 20 Aug 2014 14:18:16 GMT

example of data below. Is not the actual data however.

Re: Multiple Rows merging

RichardFairhurst — Wed, 20 Aug 2014 14:45:32 GMT

If you had ArcGIS 10.1 a standard join and an export of the data will multiply the rows to convert a one-to-many or many-to-many relationship to a one-to-one relationship. That might make some charting options work for this problem. Unfortunately, at 10.0 this is not an option and there is no tool within ArcGIS that does what the Pivot Table tool does for license levels lower than Advanced.

Excel can transpose columns and rows if you follow this procedure. That is your best bet.

If you find that you actully need multiple rows like 10.1 can produce through a Join and Export, the Make Query Table tool is the best option for converting a one-to-many or many-to-many relationship to a one-to-one relationship at 10.0 or earlier.