Question

Combine Data into one row for each ID

  • 14 March 2019
  • 1 reply
  • 27 views
ingalla
Rank
Badge +9

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
Rank
Userlevel 6
Badge +33

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

28,723
Posts
109,511
Replies
36,559
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.