An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
<?xml version="1.0" encoding="UTF-8" standalone="no"?><process version="5.3.000"> <context> <input/> <output/> <macros/> </context> <operator activated="true" class="process" compatibility="5.3.000" expanded="true" name="Process"> <process expanded="true" height="434" width="767"> <operator activated="true" class="generate_transaction_data" compatibility="5.3.000" expanded="true" height="60" name="Generate Transaction Data" width="90" x="45" y="30"> <parameter key="number_transactions" value="1000"/> <parameter key="number_customers" value="100"/> <parameter key="number_items" value="3"/> </operator> <operator activated="true" class="rename" compatibility="5.3.000" expanded="true" height="76" name="Rename" width="90" x="179" y="30"> <parameter key="old_name" value="Item"/> <parameter key="new_name" value="Sensor"/> <list key="rename_additional_attributes"/> </operator> <operator activated="true" class="rename" compatibility="5.3.000" expanded="true" height="76" name="Rename (2)" width="90" x="313" y="30"> <parameter key="old_name" value="Amount"/> <parameter key="new_name" value="Value"/> <list key="rename_additional_attributes"/> </operator> <operator activated="true" class="set_role" compatibility="5.3.000" expanded="true" height="76" name="Set Role" width="90" x="447" y="30"> <parameter key="name" value="Id"/> <list key="set_additional_roles"/> </operator> <operator activated="true" class="pivot" compatibility="5.3.000" expanded="true" height="76" name="Pivot" width="90" x="581" y="30"> <parameter key="group_attribute" value="Id"/> <parameter key="index_attribute" value="Sensor"/> </operator> <connect from_op="Generate Transaction Data" from_port="output" to_op="Rename" to_port="example set input"/> <connect from_op="Rename" from_port="example set output" to_op="Rename (2)" to_port="example set input"/> <connect from_op="Rename (2)" 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="Pivot" to_port="example set input"/> <connect from_op="Pivot" 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>
<?xml version="1.0" encoding="UTF-8" standalone="no"?><process version="5.3.000"> <context> <input/> <output/> <macros/> </context> <operator activated="true" class="process" compatibility="5.3.000" expanded="true" name="Process"> <process expanded="true" height="235" width="480"> <operator activated="true" class="subprocess" compatibility="5.3.000" expanded="true" height="76" name="Generate Data" width="90" x="45" y="30"> <process expanded="true" height="452" width="300"> <operator activated="true" class="generate_sales_data" compatibility="5.3.000" expanded="true" height="60" name="Generate Sales Data" width="90" x="45" y="30"/> <operator activated="true" class="generate_attributes" compatibility="5.3.000" expanded="true" height="76" name="Generate Attributes" width="90" x="180" y="30"> <list key="function_descriptions"> <parameter key="date" value="date_add(date, rand()*24*60, DATE_UNIT_MINUTE)"/> </list> </operator> <connect from_op="Generate Sales Data" from_port="output" to_op="Generate Attributes" to_port="example set input"/> <connect from_op="Generate Attributes" from_port="example set output" to_port="out 1"/> <portSpacing port="source_in 1" spacing="0"/> <portSpacing port="sink_out 1" spacing="0"/> <portSpacing port="sink_out 2" spacing="0"/> </process> </operator> <operator activated="true" class="generate_attributes" compatibility="5.3.000" expanded="true" height="76" name="Generate Attributes (2)" width="90" x="179" y="30"> <list key="function_descriptions"> <parameter key="five_minute_intervals_since_1970" value="floor(date_diff(date_parse_custom("01-01-1970", "dd-MM-yyyy"), date) / (5*60*1000))"/> </list> </operator> <operator activated="true" class="aggregate" compatibility="5.3.000" expanded="true" height="76" name="Aggregate" width="90" x="313" y="30"> <list key="aggregation_attributes"> <parameter key="amount" value="average"/> <parameter key="date" value="minimum"/> </list> <parameter key="group_by_attributes" value="|five_minute_intervals_since_1970"/> </operator> <connect from_op="Generate Data" from_port="out 1" to_op="Generate Attributes (2)" to_port="example set input"/> <connect from_op="Generate Attributes (2)" from_port="example set 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>