I am trying to concatenate records in a field with commas to separate. the field sometimes has repeating records that I do not want to concatenate into the new field, I only want to concatenate one occurrence of each different value into the new field an example would be
Landform1 (this is the field name) of the Landscape Table: the records in the field are:
hills
hills
hills
mountains
drainages
mountains
and I want: hills, mountains, drainages.as a string in the new field "Landform2" of the Landscape Table... Can anyone help?
Landform1 (this is the field name) of the Landscape Table: the records in the field are:
hills
hills
hills
mountains
drainages
mountains
and I want: hills, mountains, drainages.as a string in the new field "Landform2" of the Landscape Table... Can anyone help?