Skip to main content
Question

Combine Data into one row for each ID

  • March 14, 2019
  • 1 reply
  • 133 views
ingalla
Contributor
Forum|alt.badge.img+10

Hi

 

I have created a workbench which provides calculations based on a test filter. I have 10 different calculations in total to perform on various attributes in the data, but want to bring all of the resultsinto one record all based on the same TOID identifier. How can i acheive this as at present i am getting as follows

TOID

 

Calc 1

 

Calc 2

 

CAlc 3

 

1234

 

125

 

Missing

 

Missing

 

1234

 

Missing

 

142

 

Missing

 

1234

 

Missing

 

Missing

 

165

 

 

What I want to acheive is below

TOID

 

Calc 1

 

Calc 2

 

Calc 3

 

1234

 

125

 

142

 

165

 

 

Thanks

Andy

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.

1 reply

nielsgerrits
VIP
Forum|alt.badge.img+61

Aggregator.

Group by TOID (one outputfeature for all inputfeatures where TOID is the same)

Concatenate CALC1, CALC2, CALC3 (Merge these values of these attributes to only one value for each attribute. As the other values are missing, the result will be only the not missing value.)

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...

Community Stats

32,120
Posts
121,954
Replies
39,772
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.