(Again) Is this sort of �??summery�?� possible in the ArcGIS?

All the time we are required to summarize the data as shown in the following example.

Data:

Field1 Field2 Field3 Field4

1 S1 M1 K1

1 S2 M1 K2

1 S3 M1 K3

1 S4 M2 K3

1 S5 M2 K3

2 S1 M1 K1

2 S2 M1 K1

2 S3 M1 K2

2 S4 M1 K2

3 S1 M1 K1

3 S2 M1 K2

3 S3 M2 K2

Summery:

Field1 Field2 Field3 Field4

1 S1, S2, S3, S4, S5 M1, M2 K1, K2, K3

2 S1, S2, S3, S4 M1 K1, K2

3 S1, S2, S2 M1, M2 K1, K2

It is obvious that the �??Field1�?� is taken as the �??Case field�?� while the other fields are filled with all non-repeated possible values separated by commas.

The table is attached (i think that this forum is not able to show the tables properly! why they don't enhance it?)

Thank you in advance for the help

Best

Jamal

All the time we are required to summarize the data as shown in the following example.

Data:

Field1 Field2 Field3 Field4

1 S1 M1 K1

1 S2 M1 K2

1 S3 M1 K3

1 S4 M2 K3

1 S5 M2 K3

2 S1 M1 K1

2 S2 M1 K1

2 S3 M1 K2

2 S4 M1 K2

3 S1 M1 K1

3 S2 M1 K2

3 S3 M2 K2

Summery:

Field1 Field2 Field3 Field4

1 S1, S2, S3, S4, S5 M1, M2 K1, K2, K3

2 S1, S2, S3, S4 M1 K1, K2

3 S1, S2, S2 M1, M2 K1, K2

It is obvious that the �??Field1�?� is taken as the �??Case field�?� while the other fields are filled with all non-repeated possible values separated by commas.

The table is attached (i think that this forum is not able to show the tables properly! why they don't enhance it?)

Thank you in advance for the help

Best

Jamal

Possible, yes. Easy, no. Without programming in Python or ArcObjects this can only be done in many steps for one field pair at a time. It would take approximately 35 separate tool steps to create the final output table with 3 comma separated fields using just the ModelBuilder tools available with an ArcInfo license (the correct combination of Summary Statistics, Add Field, Join, Field Calculator, and Pivot Table). I've done it, but it is not pretty. (I'll describe the process if you wish, but if someone has written a custom program it is bound to be much easier).

A Python or ArcObjects program would have to replicate most of those same steps to create the 3 separate sorted arrays of values that are in your final output, so what you want is quite a complex operation. At some poiint I thought I saw a post about either a Python program or an Add-In that did this for a field pair, but now I cannot find it. I have heard that SQL Server may be able to do this type of operation for a single field pair in one go, but not actually seen it in action. I am not aware of any program that would deal with all 4 fields at once.