topic Re: Data Reviewer: Unique composite value check in Data Reviewer Support Group Questions

Data Reviewer: Unique composite value check

SeetharamVeeramachaneni — Fri, 25 May 2018 02:06:47 GMT

In Data Reviewer Unique ID Check can be used to check if an attribute is unique in feature class.

I have a requirement to create Data Reviewer batch job to check combination of more than one attributes in feature class is unique.

City	Street
Madison	Glenwood Ave
Madison	W Main St
Sun Prairie	E Main St
Sun Prairie	E Main St

In above example combination of city and street should be unique. Data reviewer should display row # 3 and 4 as errors.

Any pointers or help is greatly appreciated.

Re: Data Reviewer: Unique composite value check

MichelleJohnson — Thu, 31 May 2018 00:24:51 GMT

You can use the table to table attribute check to find these kind of duplicates. Select the fields you want to do an attribute comparison and then also include ObjectID <> ObjectID.

Also, when using the table to table attribute check, it is best to index the fields you are using in your attribute comparison for better performance.

Re: Data Reviewer: Unique composite value check

SeetharamVeeramachaneni — Mon, 04 Jun 2018 12:58:17 GMT

Thanks Michelle..!

I implemented table to table attribute check. This check is good as long as both city and street fields are not null, if any one field is null or blank this check fails.

City	Street
Madison	Glenwood Ave
Madison	W Main St
Sun Prairie
SunPrairie
<NULL>	E Main St
<NULL>	E Main St

As a work around, I created new filed with concatenated value of city and street and implemented Unique ID check.

But I would like to avoid creating new field if possible.