concatenate multi values in one record without duplication
- by mikehjun
I have a dbf table like below which is the result of one to many join from two tables. I want to have unique zone values from one Taxlot id field.
table name: input table
tid ----- zone
1 ------ A
1 ------ A
1 ------ B
1 ------ C
2 ------ D
2 ------ E
3 ------ C
Desirable output table
table name: input table
tid ----- zone
1 ------ A, B, C
2…