Find min_value of one attribute after group_by and keep all the other attributes of that line

amaury_demeloso
New Altair Community Member
Hi Everyone,
I have a simple problem to solve but could not figure it out yet. I have an ExampleSet where I can use the Aggregation operator to find the minimun(Attribute_A) with group_by (Attribute_B). My problem is that I want to keep also the other attributes (say Attributes_C,D,E ...) for that particular line of data from which Attribute_A is minimum.
I hope that is clear enough!
Amaury
I have a simple problem to solve but could not figure it out yet. I have an ExampleSet where I can use the Aggregation operator to find the minimun(Attribute_A) with group_by (Attribute_B). My problem is that I want to keep also the other attributes (say Attributes_C,D,E ...) for that particular line of data from which Attribute_A is minimum.
I hope that is clear enough!
Amaury
Tagged:
0
Answers
-
Hi @amaury_demeloso ,can't we just join on the two attributes? See attached example.BR,Martin
<?xml version="1.0" encoding="UTF-8"?><process version="9.2.000"><br> <context><br> <input/><br> <output/><br> <macros/><br> </context><br> <operator activated="true" class="process" compatibility="9.2.000" expanded="true" name="Process"><br> <parameter key="logverbosity" value="init"/><br> <parameter key="random_seed" value="2001"/><br> <parameter key="send_mail" value="never"/><br> <parameter key="notification_email" value=""/><br> <parameter key="process_duration_for_mail" value="30"/><br> <parameter key="encoding" value="SYSTEM"/><br> <process expanded="true"><br> <operator activated="true" class="retrieve" compatibility="9.2.000" expanded="true" height="68" name="Retrieve Golf" width="90" x="45" y="238"><br> <parameter key="repository_entry" value="//Samples/data/Golf"/><br> </operator><br> <operator activated="true" class="generate_id" compatibility="9.2.000" expanded="true" height="82" name="Generate ID" width="90" x="246" y="238"><br> <parameter key="create_nominal_ids" value="false"/><br> <parameter key="offset" value="0"/><br> </operator><br> <operator activated="true" class="aggregate" compatibility="9.2.000" expanded="true" height="82" name="Aggregate" width="90" x="447" y="136"><br> <parameter key="use_default_aggregation" value="false"/><br> <parameter key="attribute_filter_type" value="all"/><br> <parameter key="attribute" value=""/><br> <parameter key="attributes" value=""/><br> <parameter key="use_except_expression" value="false"/><br> <parameter key="value_type" value="attribute_value"/><br> <parameter key="use_value_type_exception" value="false"/><br> <parameter key="except_value_type" value="time"/><br> <parameter key="block_type" value="attribute_block"/><br> <parameter key="use_block_type_exception" value="false"/><br> <parameter key="except_block_type" value="value_matrix_row_start"/><br> <parameter key="invert_selection" value="false"/><br> <parameter key="include_special_attributes" value="false"/><br> <parameter key="default_aggregation_function" value="average"/><br> <list key="aggregation_attributes"><br> <parameter key="Temperature" value="minimum"/><br> </list><br> <parameter key="group_by_attributes" value="Wind"/><br> <parameter key="count_all_combinations" value="false"/><br> <parameter key="only_distinct" value="false"/><br> <parameter key="ignore_missings" value="true"/><br> </operator><br> <operator activated="true" class="concurrency:join" compatibility="9.2.000" expanded="true" height="82" name="Join" width="90" x="581" y="136"><br> <parameter key="remove_double_attributes" value="true"/><br> <parameter key="join_type" value="inner"/><br> <parameter key="use_id_attribute_as_key" value="false"/><br> <list key="key_attributes"><br> <parameter key="minimum(Temperature)" value="Temperature"/><br> <parameter key="Wind" value="Wind"/><br> </list><br> <parameter key="keep_both_join_attributes" value="false"/><br> </operator><br> <connect from_op="Retrieve Golf" from_port="output" to_op="Generate ID" to_port="example set input"/><br> <connect from_op="Generate ID" from_port="example set output" to_op="Aggregate" to_port="example set input"/><br> <connect from_op="Aggregate" from_port="example set output" to_op="Join" to_port="left"/><br> <connect from_op="Aggregate" from_port="original" to_op="Join" to_port="right"/><br> <connect from_op="Join" from_port="join" to_port="result 1"/><br> <portSpacing port="source_input 1" spacing="0"/><br> <portSpacing port="sink_result 1" spacing="0"/><br> <portSpacing port="sink_result 2" spacing="0"/><br> </process><br> </operator><br></process><br><br>
0