An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Hi!
I have this dataset
userid time
1 28
1 29
2 34
3 2
1 5
2 6
I need to order this data by user and then by time so the desired result is
user time
How can I do it? It doesn't work by using 2 sorts in any order.....
I've found the solution: it works by ordering in the other way: first by time and then by user.
There is a very nice multi-attribute Sort operator in the Jackhammer extension in the Marketplace.
Hi,
You would need a combination of Sort, Group into collection and loop collection operator to achieve this task.
Here is the XML code for the sample process for the same.
<?xml version="1.0" encoding="UTF-8"?><process version="8.1.000"> <context> <input/> <output/> <macros/> </context> <operator activated="true" class="process" compatibility="8.1.000" expanded="true" name="Process"> <process expanded="true"> <operator activated="true" class="operator_toolbox:create_exampleset_from_doc" compatibility="0.9.000" expanded="true" height="68" name="Create ExampleSet" width="90" x="112" y="34"> <parameter key="Input Csv" value="userid,time 1,28 1,29 2,34 3,2 1,5 2,6"/> </operator> <operator activated="true" class="sort" compatibility="8.1.000" expanded="true" height="82" name="Sort" width="90" x="246" y="34"> <parameter key="attribute_name" value="userid"/> </operator> <operator activated="true" class="numerical_to_polynominal" compatibility="8.1.000" expanded="true" height="82" name="Numerical to Polynominal" width="90" x="380" y="34"> <parameter key="attribute_filter_type" value="single"/> <parameter key="attribute" value="userid"/> </operator> <operator activated="true" class="set_role" compatibility="8.1.000" expanded="true" height="82" name="Set Role" width="90" x="514" y="34"> <parameter key="attribute_name" value="userid"/> <parameter key="target_role" value="id"/> <list key="set_additional_roles"/> </operator> <operator activated="true" class="operator_toolbox:group_into_collection" compatibility="0.9.000" expanded="true" height="82" name="Group Into Collection" width="90" x="648" y="34"> <parameter key="group_by_attribute" value="userid"/> </operator> <operator activated="true" class="loop_collection" compatibility="8.1.000" expanded="true" height="82" name="Loop Collection" width="90" x="782" y="34"> <process expanded="true"> <operator activated="true" class="sort" compatibility="8.1.000" expanded="true" height="82" name="Sort (2)" width="90" x="179" y="34"> <parameter key="attribute_name" value="time"/> </operator> <connect from_port="single" to_op="Sort (2)" to_port="example set input"/> <connect from_op="Sort (2)" from_port="example set output" to_port="output 1"/> <portSpacing port="source_single" spacing="0"/> <portSpacing port="sink_output 1" spacing="0"/> <portSpacing port="sink_output 2" spacing="0"/> </process> </operator> <operator activated="true" class="append" compatibility="8.1.000" expanded="true" height="82" name="Append" width="90" x="916" y="34"/> <connect from_op="Create ExampleSet" from_port="output" to_op="Sort" to_port="example set input"/> <connect from_op="Sort" from_port="example set output" to_op="Numerical to Polynominal" to_port="example set input"/> <connect from_op="Numerical to Polynominal" from_port="example set output" to_op="Set Role" to_port="example set input"/> <connect from_op="Set Role" from_port="example set output" to_op="Group Into Collection" to_port="exa"/> <connect from_op="Group Into Collection" from_port="col" to_op="Loop Collection" to_port="collection"/> <connect from_op="Loop Collection" from_port="output 1" to_op="Append" to_port="example set 1"/> <connect from_op="Append" from_port="merged set" 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>
Hope this helps.
Cheers,
