Skip to main content
Question

Merge records into one row


Forum|alt.badge.img

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

2 replies

ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • August 29, 2023

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


Forum|alt.badge.img
ebygomm wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings