The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
writing excel files
Contributor I
Currently when I am running my old processes on RapidMiner 9.0, I see a strange beahavior. After joining the results, I used to write them down with WRITE EXCEL operatoer, but now, when I am doing the same, the write excel operator doesn't give me a path to sote the file.
See the following xml.
Regards.
Mansour
See the following xml.
Regards.
Mansour
<?xml version="1.0" encoding="UTF-8"?><process version="9.3.001">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="6.0.002" expanded="true" name="Process">
<parameter key="logverbosity" value="init"/>
<parameter key="random_seed" value="2001"/>
<parameter key="send_mail" value="never"/>
<parameter key="notification_email" value=""/>
<parameter key="process_duration_for_mail" value="30"/>
<parameter key="encoding" value="SYSTEM"/>
<process expanded="true">
<operator activated="true" class="retrieve" compatibility="9.3.001" expanded="true" height="68" name="Retrieve Premium_Everyday" width="90" x="45" y="34">
<parameter key="repository_entry" value="//MEQ CloudStore/26 June 2019/Data Lamb/Premium_Everyday/Premium_Everyday"/>
</operator>
<operator activated="true" class="select_attributes" compatibility="9.3.001" expanded="true" height="82" name="Select Attributes" width="90" x="179" y="30">
<parameter key="attribute_filter_type" value="all"/>
<parameter key="attribute" value="AA"/>
<parameter key="attributes" value=""/>
<parameter key="use_except_expression" value="false"/>
<parameter key="value_type" value="numeric"/>
<parameter key="use_value_type_exception" value="false"/>
<parameter key="except_value_type" value="time"/>
<parameter key="block_type" value="attribute_block"/>
<parameter key="use_block_type_exception" value="false"/>
<parameter key="except_block_type" value="value_matrix_row_start"/>
<parameter key="invert_selection" value="true"/>
<parameter key="include_special_attributes" value="false"/>
</operator>
<operator activated="true" class="replace_missing_values" compatibility="5.2.000" expanded="true" height="103" name="Replace Missing Values" width="90" x="313" y="34">
<parameter key="return_preprocessing_model" value="false"/>
<parameter key="create_view" value="false"/>
<parameter key="attribute_filter_type" value="all"/>
<parameter key="attribute" value=""/>
<parameter key="attributes" value=""/>
<parameter key="use_except_expression" value="false"/>
<parameter key="value_type" value="numeric"/>
<parameter key="use_value_type_exception" value="false"/>
<parameter key="except_value_type" value="time"/>
<parameter key="block_type" value="attribute_block"/>
<parameter key="use_block_type_exception" value="false"/>
<parameter key="except_block_type" value="value_matrix_row_start"/>
<parameter key="invert_selection" value="false"/>
<parameter key="include_special_attributes" value="false"/>
<parameter key="default" value="none"/>
<list key="columns"/>
</operator>
<operator activated="true" class="multiply" compatibility="9.3.001" expanded="true" height="103" name="Multiply" width="90" x="45" y="187"/>
<operator activated="true" class="weight_by_uncertainty" compatibility="9.3.001" expanded="true" height="82" name="Weight by Uncertainty" width="90" x="179" y="187">
<parameter key="normalize_weights" value="true"/>
<parameter key="sort_weights" value="true"/>
<parameter key="sort_direction" value="ascending"/>
<parameter key="number_of_bins" value="10"/>
</operator>
<operator activated="true" class="weights_to_data" compatibility="9.3.001" expanded="true" height="68" name="Weights to Data (7)" width="90" x="313" y="187"/>
<operator activated="true" class="set_role" compatibility="9.3.001" expanded="true" height="82" name="Set Role (8)" width="90" x="447" y="187">
<parameter key="attribute_name" value="Attribute"/>
<parameter key="target_role" value="id"/>
<list key="set_additional_roles"/>
</operator>
<operator activated="true" class="rename" compatibility="9.3.001" expanded="true" height="82" name="Rename (7)" width="90" x="581" y="187">
<parameter key="old_name" value="Weight"/>
<parameter key="new_name" value="Weight_Uncertainty"/>
<list key="rename_additional_attributes"/>
</operator>
<operator activated="true" class="weight_by_relief" compatibility="9.3.001" expanded="true" height="82" name="Weight by Relief" width="90" x="179" y="340">
<parameter key="normalize_weights" value="true"/>
<parameter key="sort_weights" value="true"/>
<parameter key="sort_direction" value="ascending"/>
<parameter key="number_of_neighbors" value="10"/>
<parameter key="sample_ratio" value="1.0"/>
<parameter key="use_local_random_seed" value="false"/>
<parameter key="local_random_seed" value="1992"/>
</operator>
<operator activated="true" class="weights_to_data" compatibility="9.3.001" expanded="true" height="68" name="Weights to Data (8)" width="90" x="313" y="340"/>
<operator activated="true" class="set_role" compatibility="9.3.001" expanded="true" height="82" name="Set Role (7)" width="90" x="447" y="340">
<parameter key="attribute_name" value="Attribute"/>
<parameter key="target_role" value="id"/>
<list key="set_additional_roles"/>
</operator>
<operator activated="true" class="rename" compatibility="9.3.001" expanded="true" height="82" name="Rename (8)" width="90" x="581" y="340">
<parameter key="old_name" value="Weight"/>
<parameter key="new_name" value="Weight_Relief"/>
<list key="rename_additional_attributes"/>
</operator>
<operator activated="true" class="concurrency:join" compatibility="9.3.001" expanded="true" height="82" name="Join (3)" width="90" x="782" y="238">
<parameter key="remove_double_attributes" value="true"/>
<parameter key="join_type" value="inner"/>
<parameter key="use_id_attribute_as_key" value="true"/>
<list key="key_attributes">
<parameter key="Attribute" value="Attribute"/>
</list>
<parameter key="keep_both_join_attributes" value="false"/>
</operator>
<operator activated="true" class="multiply" compatibility="9.3.001" expanded="true" height="103" name="Multiply (2)" width="90" x="916" y="238"/>
<operator activated="true" class="write_excel" compatibility="9.3.001" expanded="true" height="103" name="Write Excel" width="90" x="1050" y="238">
<parameter key="file_format" value="xlsx"/>
<enumeration key="sheet_names"/>
<parameter key="sheet_name" value="RapidMiner Data"/>
<parameter key="date_format" value="yyyy-MM-dd HH:mm:ss"/>
<parameter key="number_format" value="#.0"/>
<parameter key="encoding" value="SYSTEM"/>
</operator>
<operator activated="true" class="write_csv" compatibility="9.3.001" expanded="true" height="82" name="Write CSV" width="90" x="1050" y="391">
<parameter key="csv_file" value="/Users/mansour/Documents/test.csv"/>
<parameter key="column_separator" value=";"/>
<parameter key="write_attribute_names" value="true"/>
<parameter key="quote_nominal_values" value="true"/>
<parameter key="format_date_attributes" value="true"/>
<parameter key="append_to_file" value="false"/>
<parameter key="encoding" value="SYSTEM"/>
</operator>
<operator activated="true" class="write_csv" compatibility="9.3.001" expanded="true" height="82" name="Write CSV (2)" width="90" x="983" y="136">
<parameter key="column_separator" value=";"/>
<parameter key="write_attribute_names" value="true"/>
<parameter key="quote_nominal_values" value="true"/>
<parameter key="format_date_attributes" value="true"/>
<parameter key="append_to_file" value="false"/>
<parameter key="encoding" value="SYSTEM"/>
</operator>
<connect from_op="Retrieve Premium_Everyday" from_port="output" to_op="Select Attributes" to_port="example set input"/>
<connect from_op="Select Attributes" from_port="example set output" to_op="Replace Missing Values" to_port="example set input"/>
<connect from_op="Replace Missing Values" from_port="example set output" to_op="Multiply" to_port="input"/>
<connect from_op="Multiply" from_port="output 1" to_op="Weight by Relief" to_port="example set"/>
<connect from_op="Multiply" from_port="output 2" to_op="Weight by Uncertainty" to_port="example set"/>
<connect from_op="Weight by Uncertainty" from_port="weights" to_op="Weights to Data (7)" to_port="attribute weights"/>
<connect from_op="Weights to Data (7)" from_port="example set" to_op="Set Role (8)" to_port="example set input"/>
<connect from_op="Set Role (8)" from_port="example set output" to_op="Rename (7)" to_port="example set input"/>
<connect from_op="Rename (7)" from_port="example set output" to_op="Join (3)" to_port="left"/>
<connect from_op="Weight by Relief" from_port="weights" to_op="Weights to Data (8)" to_port="attribute weights"/>
<connect from_op="Weights to Data (8)" from_port="example set" to_op="Set Role (7)" to_port="example set input"/>
<connect from_op="Set Role (7)" from_port="example set output" to_op="Rename (8)" to_port="example set input"/>
<connect from_op="Rename (8)" from_port="example set output" to_op="Join (3)" to_port="right"/>
<connect from_op="Join (3)" from_port="join" to_op="Multiply (2)" to_port="input"/>
<connect from_op="Multiply (2)" from_port="output 1" to_op="Write Excel" to_port="input"/>
<connect from_op="Multiply (2)" from_port="output 2" to_op="Write CSV" to_port="input"/>
<connect from_op="Write Excel" from_port="file" to_port="result 1"/>
<connect from_op="Write CSV" from_port="through" to_port="result 2"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="189"/>
<portSpacing port="sink_result 2" spacing="21"/>
<portSpacing port="sink_result 3" spacing="0"/>
</process>
</operator>
</process>
Tagged:
0
Answers
MarlaBot
If write excel doesn't work, when you run your process and you are in results, you can move to TurpoPrep and from there choose export to Excel.
I hope it helps.
It is a simple connection mistake. You connected "fil" of Excel operator to "Res" instead of "thr" to "Res". This is the reason you did not get the location option. You need to connect "thr" to "res" and it resolves the issue. See below image for reference.
Hope this helps.
Varun
https://www.varunmandalapu.com/
Be Safe. Follow precautions and Maintain Social Distancing