Skip to main content
  • EN

Greetings,

I used FeatureJoiner to merge a Spatial and non-spatial records using a common value (grid_id).

 

I use a Tester to select a scenario ie date is 2000, 2030, 2040, etc.

I then use a StringConcaternator to add a value to a cell (overwrite cell value), the cell for 2000 will be 0 -5.

 

I also have a Tester for 2030 (2C), 2030 (4C), 2040 (2C), 2040 (4C), etc.

 

The records in the FeatureHolder, should all be written to a single row.

Instead I have a row per date/scenario??

 

For 2000 I have the following data.

imageimage 

The output is written over n rows, not a single row??

image 

How do I append records into a single row??

Any suggestions are appreciated.

 

Thanks

Clive

To get from your last image to a single row, use an Aggregator with a group by on your grid_id, set Accumulation Mode - merge incoming attributes

To get from your last image to a single row, use an Aggregator with a group by on your grid_id, set Accumulation Mode - merge incoming attributes

Hi,

Thanks forgot about the Aggregator, that concatenated the records into a single row.

Reply


Community Stats

30,368
Posts
115,378
Replies
38,145
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.