Select to view content in your preferred language

Concatenating data from several elements by group

04-05-2022 03:55 AM
Occasional Contributor III

I have a series of features, split by complex, group and site. Each feature has various attributes at the site level such as PERIOD and TYPE. I need to be able to group all the features at the Group level, giving all the attributes from a group to each group; e.g. if I have 3 sites in group TV1.3 with different attributes (TV1.3.1 PERIOD = BRONZE AGE and TYPE = ROUND BARROW; TV1.3.2 PERIOD = BRONZE AGE and TYPE = POND BARROW; TV1.3.3 PERIOD = BRONZE AGE and TYPE = SAUCER BARROW) I want to create a table where TV1.3  PERIOD = BRONZE AGE and TYPE = ROUND BARROW\POND BARROW\SAUCER BARROW.

Is this possible, and if so how might I do it?

I attach a small sample of data.


0 Kudos
0 Replies