Skip to main content
  • EN

I have 100 items of data, which are grouped together in various sub groups using a field 'groupNo',

I want to process each set of groupNos individually, I need to select a group, and do the following processes for each individual group: Take one item with status 'original' which has data and duplicate that data to the 'new' items in that group. How would I do this using the groupNo identifier? 

An example input output data set:
 

Input:
OID, Status, Data, Group
1, Original, XYZ, 1

2, New, <null>, 1

3, Original, ABC, 2

4, New, <null>, 2

5, New, <null>, 2

 

Output:

OID, Status, Data, Group
1, Original, XYZ, 1

2, New, XYZ, 1

3, Original, ABC, 2

4, New, ABC, 2

5, New, ABC, 2

 

 

There are many ways to process it. You can use FeatureMerge to merge attributes. Firstly, you have to filter Null value and has a value of "Data" field, then you can use set of Null data as Requestor with key "Group", and set of has a value data for Suplier with key "Group". You will have a result with features with attributes are merged, then use another transformers to get attributes you need such as AttributeRenamer, CreatorAttribute, AttributeValueMapper.....

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.