Skip to main content
  • EN

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

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

Reply


Community Stats

30,364
Posts
115,373
Replies
38,142
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.