Solved

Trying to add an attribute to numerous records


Badge +2

I have a process where I determine the last ID number used for two id fields using statistics calculator. I then use an aggregator to merge the two ID's. I then bring about 100 records from another table and am wanting to add these ID's to it. But what is happening is that the two ID's are just being added as another record instead. I have tried using variable setter & retriever but those didn't work at all.

icon

Best answer by redgeographics 13 May 2022, 08:53

View original

6 replies

Userlevel 4
Badge +25

Try a FeatureMerger or FeatureJoiner, using the id field as your join key.

Badge +2

Try a FeatureMerger or FeatureJoiner, using the id field as your join key.

I can't do that as what I am trying to do is add the id created as the new id for the 100 records.

Userlevel 4
Badge +25

I can't do that as what I am trying to do is add the id created as the new id for the 100 records.

Aha, in that case you can use a Sampler to split off 1 feature that has the new id and merge that to the 100 other ones using a FeatureMerger or FeatureJoiner. You'll need to set the join key to the same value on both sides, so, for example, 1 and 1.

Badge +2

I can't do that as what I am trying to do is add the id created as the new id for the 100 records.

Tried it. It just added the id as it's own row with the id field filled in and everything else is blank. This is what I am finding with everything else I tried also. Thanks for the idea though.

Userlevel 1
Badge +10

I can't do that as what I am trying to do is add the id created as the new id for the 100 records.

Can you share a screenshot of your workspace? This should be easily possible, there may be some settings in the FeatureMerger you need to tweak in case of attribute conflict.

 

Badge +2

I can't do that as what I am trying to do is add the id created as the new id for the 100 records.

I got the featureMerger working. Thanks for your help! That did the job.

Reply