I have a table of data below which I need to copy the property number to the null fields in the other records for that uprn? Any ideas?
Page 1 / 1
If you use a featuremerger merging on the UPRN with conflict resolution set to Use Supplier then that should work (assuming the attribute containing the property number is the same in both sets of data, you've not included a sample)
Hi @rdcagale
does your data look like
recNumber propertyNumber
1 1
2 NULL
3 NULL
4 2
5 NULL? Would you need to set record 2 and 3 propertyNumber to 1 and record 5 propertyNumber to 2? If yes, you can use AttributeCreator with adjacent features and conditional values:
Hi
The need is to automate this process as there are well over 600K records.
The UPRN field groups the data, and hopefully a property field value will be in the data set.
The need is for all records with the same uprn to have the same property value.
table.png
@rdcagale you can use a featuremerger as follows for that sort of data structure
Hi @rdcagale
does your data look like
recNumber propertyNumber
1 1
2 NULL
3 NULL
4 2
5 NULL? Would you need to set record 2 and 3 propertyNumber to 1 and record 5 propertyNumber to 2? If yes, you can use AttributeCreator with adjacent features and conditional values:
many thanks for the idea.
However, I want to automate the process and there are over 600K records to do.
The UPRN field holds the group of records and I need the property value to be the same in all records with the same uprn. The property value could be in any of the records.