Skip to main content
Question

Combine Data into one row for each ID

  • March 14, 2019
  • 1 reply
  • 114 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

1 reply

nielsgerrits
VIP
Forum|alt.badge.img+54

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.)


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