sum columns ??

eselva
New Altair Community Member
Answers
-
Hi,
you can do this using the aggregate operator. It works similar to the aggregate in SQL.
~Martin0 -
i cant it. I just sum one colum? how?0
-
Hi eselva,
try out the process below. This should illustrate it.
Martin
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="6.5.002">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="6.5.002" expanded="true" name="Process">
<process expanded="true">
<operator activated="true" class="retrieve" compatibility="6.5.002" expanded="true" height="60" name="Retrieve Sonar" width="90" x="45" y="120">
<parameter key="repository_entry" value="//Samples/data/Sonar"/>
</operator>
<operator activated="true" class="aggregate" compatibility="6.5.002" expanded="true" height="76" name="Aggregate" width="90" x="179" y="120">
<list key="aggregation_attributes">
<parameter key="attribute_1" value="sum"/>
</list>
</operator>
<connect from_op="Retrieve Sonar" from_port="output" to_op="Aggregate" to_port="example set input"/>
<connect from_op="Aggregate" from_port="example set output" to_port="result 1"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
<portSpacing port="sink_result 2" spacing="0"/>
</process>
</operator>
</process>0