What expression do I use a field calculator to concatenate all fields into one and also have the field name included in the concatenation?

12-30-2016 11:59 AM
New Contributor

I would like to combine all attributes into one field and also have it include the field name.

0 Kudos
2 Replies
MVP Legendary Contributor

You have posted this in the ArcGIS Python API  ... by chance do you want to do this to go to the   https://community.esri.com/community/developers/gis-developers/python?sr=search&searchId=8bdf3142-ec...‌ place? or are you interested in https://community.esri.com/community/gis/managing-data?sr=search&searchId=ea73d205-1a03-4b5c-b899-26...‌ perhaps?

And you indicate that you want to do this in the field calculator as well.  Do you have an example of how you do this now... because you normally provide the field name or names in a field calculator expression. Perhaps you could elaborate on the result you are after to help guide further discussion.

MVP Esteemed Contributor

Although you are asking about the field calculator for doing this, have you thought about exporting all the data to a comma delimited .csv or excel file....doing a little manipulations there and then joining the attribute table back?  If this is a one shot deal, that may be more straight forward.  The hard part you may have is if they are not fixed length, how will you use the data in the fields.  This may not be important for your purposes, but without more explain atin it will be hard to give much more advice.

as Dan mentioned, you have this in the Python API geonet space...is that what you are trying to use?  If not, you may want to try https://community.esri.com/docs/DOC-2258?sr=search&searchId=99975afe-dd7e-49c5-be74-e398ecd7125e&sea...‌ to move it to a a different community on geonet.  Since this is from a few weeks ago, if it it resolved, please mark it as assumed answered....and a summary would be nice.  If still an issu, please provide more detail.

0 Kudos