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?
Solved
copy an attribute from one record with another. Where the another reference is the same value
Best answer by ebygomm
@rdcagale you can use a featuremerger as follows for that sort of data structure
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+46- Influencer
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
+46- Influencer
- Best Answer
@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.