Update new row into existing excel file.
muhd_ikram
New Altair Community Member
Hi. How to update our existing excel file with new row without replacing it every time the Machine Learning give new result?
If possible could you show me by using operator? I'm not good with reading code.
The problem start after Machine Learning part.
I don't really know how to use the append operator correctly and if work, it still rewrite everything. I believe this how the loop read write excel looks like since I also confuse with loop operator then it tell me example not compatible, I just write and read it back to append it.
I can just copy paste it manually by doing it 1 by 1 but there hundred more in the database. haha...
Here I share my design and the xml code.
Hope you could help me or give some advise how to do it right.
Thanks.
If possible could you show me by using operator? I'm not good with reading code.
The problem start after Machine Learning part.
I don't really know how to use the append operator correctly and if work, it still rewrite everything. I believe this how the loop read write excel looks like since I also confuse with loop operator then it tell me example not compatible, I just write and read it back to append it.
I can just copy paste it manually by doing it 1 by 1 but there hundred more in the database. haha...
Here I share my design and the xml code.
Hope you could help me or give some advise how to do it right.
Thanks.
<div><?xml version="1.0" encoding="UTF-8"?><process version="9.3.001"></div><div> <context></div><div> <input/></div><div> <output/></div><div> <macros/></div><div> </context></div><div> <operator activated="true" class="process" compatibility="9.3.001" expanded="true" name="Process"></div><div> <parameter key="logverbosity" value="init"/></div><div> <parameter key="random_seed" value="2001"/></div><div> <parameter key="send_mail" value="never"/></div><div> <parameter key="notification_email" value=""/></div><div> <parameter key="process_duration_for_mail" value="30"/></div><div> <parameter key="encoding" value="SYSTEM"/></div><div> <process expanded="true"></div><div> <operator activated="true" class="jdbc_connectors:read_database" compatibility="9.3.001" expanded="true" height="82" name="Read Database" width="90" x="45" y="34"></div><div> <parameter key="define_connection" value="predefined"/></div><div> <parameter key="connection" value="Visco Lens"/></div><div> <parameter key="database_system" value="MySQL"/></div><div> <parameter key="define_query" value="query"/></div><div> <parameter key="query" value="SELECT TOP (1000) [Id] ,[GraphNo] ,[DateTime] ,[xInterval] ,[Temperature1] ,[Temperature2] ,[Temperature3] ,[Temperature4] ,[Temperature5] ,[Temperature6] FROM [Visco].[dbo].[GraphData] WHERE GraphNo = 'G20181213LADZ11' ORDER BY DateTime ASC"/></div><div> <parameter key="use_default_schema" value="true"/></div><div> <parameter key="prepare_statement" value="false"/></div><div> <enumeration key="parameters"/></div><div> <parameter key="datamanagement" value="double_array"/></div><div> <parameter key="data_management" value="auto"/></div><div> </operator></div><div> <operator activated="true" class="select_attributes" compatibility="9.3.001" expanded="true" height="82" name="Select Attributes" width="90" x="45" y="136"></div><div> <parameter key="attribute_filter_type" value="subset"/></div><div> <parameter key="attribute" value=""/></div><div> <parameter key="attributes" value="|DateTime|GraphNo|Id|Temperature1"/></div><div> <parameter key="use_except_expression" value="false"/></div><div> <parameter key="value_type" value="attribute_value"/></div><div> <parameter key="use_value_type_exception" value="false"/></div><div> <parameter key="except_value_type" value="time"/></div><div> <parameter key="block_type" value="attribute_block"/></div><div> <parameter key="use_block_type_exception" value="false"/></div><div> <parameter key="except_block_type" value="value_matrix_row_start"/></div><div> <parameter key="invert_selection" value="false"/></div><div> <parameter key="include_special_attributes" value="false"/></div><div> </operator></div><div> <operator activated="true" class="set_role" compatibility="9.3.001" expanded="true" height="82" name="Set Role" width="90" x="45" y="238"></div><div> <parameter key="attribute_name" value="GraphNo"/></div><div> <parameter key="target_role" value="id"/></div><div> <list key="set_additional_roles"></div><div> <parameter key="Temperature1" value="label"/></div><div> </list></div><div> </operator></div><div> <operator activated="true" class="time_series:forecast_validation" compatibility="9.3.001" expanded="true" height="145" name="Forecast Validation" width="90" x="179" y="34"></div><div> <parameter key="time_series_attribute" value="Temperature1"/></div><div> <parameter key="has_indices" value="true"/></div><div> <parameter key="indices_attribute" value="DateTime"/></div><div> <parameter key="window_size" value="30"/></div><div> <parameter key="no_overlapping_windows" value="false"/></div><div> <parameter key="step_size" value="1"/></div><div> <parameter key="horizon_size" value="1"/></div><div> <parameter key="enable_parallel_execution" value="true"/></div><div> <process expanded="true"></div><div> <operator activated="true" class="time_series:arima_trainer" compatibility="9.3.001" expanded="true" height="103" name="ARIMA" width="90" x="112" y="34"></div><div> <parameter key="time_series_attribute" value="Temperature1"/></div><div> <parameter key="has_indices" value="true"/></div><div> <parameter key="indices_attribute" value="DateTime"/></div><div> <parameter key="p:_order_of_the_autoregressive_model" value="1"/></div><div> <parameter key="d:_degree_of_differencing" value="0"/></div><div> <parameter key="q:_order_of_the_moving-average_model" value="1"/></div><div> <parameter key="estimate_constant" value="true"/></div><div> <parameter key="main_criterion" value="aic"/></div><div> </operator></div><div> <connect from_port="training set" to_op="ARIMA" to_port="example set"/></div><div> <connect from_op="ARIMA" from_port="forecast model" to_port="model"/></div><div> <connect from_op="ARIMA" from_port="performance" to_port="through 1"/></div><div> <portSpacing port="source_training set" spacing="0"/></div><div> <portSpacing port="sink_model" spacing="0"/></div><div> <portSpacing port="sink_through 1" spacing="0"/></div><div> <portSpacing port="sink_through 2" spacing="0"/></div><div> <description align="center" color="blue" colored="true" height="175" resized="false" width="201" x="59" y="120"><br> ARIMA is a forecast model that specialised for time series.<br>If enable indices which can be either date or time need to be in unifom order.<br><br>Need to apply same setting as Forecast Validation</description></div><div> </process></div><div> <process expanded="true"></div><div> <operator activated="true" class="performance_regression" compatibility="9.3.001" expanded="true" height="82" name="Performance" width="90" x="179" y="34"></div><div> <parameter key="main_criterion" value="first"/></div><div> <parameter key="root_mean_squared_error" value="true"/></div><div> <parameter key="absolute_error" value="true"/></div><div> <parameter key="relative_error" value="true"/></div><div> <parameter key="relative_error_lenient" value="false"/></div><div> <parameter key="relative_error_strict" value="false"/></div><div> <parameter key="normalized_absolute_error" value="false"/></div><div> <parameter key="root_relative_squared_error" value="false"/></div><div> <parameter key="squared_error" value="false"/></div><div> <parameter key="correlation" value="false"/></div><div> <parameter key="squared_correlation" value="false"/></div><div> <parameter key="prediction_average" value="false"/></div><div> <parameter key="spearman_rho" value="false"/></div><div> <parameter key="kendall_tau" value="false"/></div><div> <parameter key="skip_undefined_labels" value="true"/></div><div> <parameter key="use_example_weights" value="true"/></div><div> </operator></div><div> <connect from_port="test set" to_op="Performance" to_port="labelled data"/></div><div> <connect from_port="through 1" to_op="Performance" to_port="performance"/></div><div> <connect from_op="Performance" from_port="performance" to_port="performance 1"/></div><div> <connect from_op="Performance" from_port="example set" to_port="test set results"/></div><div> <portSpacing port="source_test set" spacing="0"/></div><div> <portSpacing port="source_through 1" spacing="0"/></div><div> <portSpacing port="source_through 2" spacing="0"/></div><div> <portSpacing port="sink_test set results" spacing="0"/></div><div> <portSpacing port="sink_performance 1" spacing="0"/></div><div> <portSpacing port="sink_performance 2" spacing="0"/></div><div> </process></div><div> </operator></div><div> <operator activated="true" class="subprocess" compatibility="9.3.001" expanded="true" height="166" name="Dummy Machine Learning" width="90" x="313" y="34"></div><div> <process expanded="true"></div><div> <operator activated="true" class="concurrency:cross_validation" compatibility="9.3.001" expanded="true" height="145" name="Cross Validation" width="90" x="112" y="85"></div><div> <parameter key="split_on_batch_attribute" value="false"/></div><div> <parameter key="leave_one_out" value="false"/></div><div> <parameter key="number_of_folds" value="10"/></div><div> <parameter key="sampling_type" value="automatic"/></div><div> <parameter key="use_local_random_seed" value="false"/></div><div> <parameter key="local_random_seed" value="1992"/></div><div> <parameter key="enable_parallel_execution" value="true"/></div><div> <process expanded="true"></div><div> <operator activated="true" class="default_model" compatibility="9.3.001" expanded="true" height="82" name="Default Model" width="90" x="112" y="34"></div><div> <parameter key="method" value="median"/></div><div> <parameter key="constant" value="0.0"/></div><div> <parameter key="attribute_name" value=""/></div><div> <description align="center" color="green" colored="true" width="126">Default learning algorithm used as dummy to validate ARIMA performance</description></div><div> </operator></div><div> <connect from_port="training set" to_op="Default Model" to_port="training set"/></div><div> <connect from_op="Default Model" from_port="model" to_port="model"/></div><div> <portSpacing port="source_training set" spacing="0"/></div><div> <portSpacing port="sink_model" spacing="0"/></div><div> <portSpacing port="sink_through 1" spacing="0"/></div><div> </process></div><div> <process expanded="true"></div><div> <operator activated="true" class="apply_model" compatibility="9.3.001" expanded="true" height="82" name="Apply Model" width="90" x="45" y="34"></div><div> <list key="application_parameters"/></div><div> <parameter key="create_view" value="false"/></div><div> </operator></div><div> <operator activated="true" class="performance_regression" compatibility="9.3.001" expanded="true" height="82" name="Performance (2)" width="90" x="179" y="34"></div><div> <parameter key="main_criterion" value="first"/></div><div> <parameter key="root_mean_squared_error" value="true"/></div><div> <parameter key="absolute_error" value="true"/></div><div> <parameter key="relative_error" value="false"/></div><div> <parameter key="relative_error_lenient" value="false"/></div><div> <parameter key="relative_error_strict" value="false"/></div><div> <parameter key="normalized_absolute_error" value="false"/></div><div> <parameter key="root_relative_squared_error" value="false"/></div><div> <parameter key="squared_error" value="false"/></div><div> <parameter key="correlation" value="false"/></div><div> <parameter key="squared_correlation" value="false"/></div><div> <parameter key="prediction_average" value="false"/></div><div> <parameter key="spearman_rho" value="false"/></div><div> <parameter key="kendall_tau" value="false"/></div><div> <parameter key="skip_undefined_labels" value="true"/></div><div> <parameter key="use_example_weights" value="true"/></div><div> </operator></div><div> <connect from_port="model" to_op="Apply Model" to_port="model"/></div><div> <connect from_port="test set" to_op="Apply Model" to_port="unlabelled data"/></div><div> <connect from_op="Apply Model" from_port="labelled data" to_op="Performance (2)" to_port="labelled data"/></div><div> <connect from_op="Performance (2)" from_port="performance" to_port="performance 1"/></div><div> <connect from_op="Performance (2)" from_port="example set" to_port="test set results"/></div><div> <portSpacing port="source_model" spacing="0"/></div><div> <portSpacing port="source_test set" spacing="0"/></div><div> <portSpacing port="source_through 1" spacing="0"/></div><div> <portSpacing port="sink_test set results" spacing="0"/></div><div> <portSpacing port="sink_performance 1" spacing="0"/></div><div> <portSpacing port="sink_performance 2" spacing="0"/></div><div> </process></div><div> </operator></div><div> <operator activated="true" class="subprocess" compatibility="9.3.001" expanded="true" height="82" name="Subprocess" width="90" x="313" y="187"></div><div> <process expanded="true"></div><div> <operator activated="true" class="sort" compatibility="9.3.001" expanded="true" height="82" name="Sort (2)" width="90" x="45" y="34"></div><div> <parameter key="attribute_name" value="Last DateTime in window"/></div><div> <parameter key="sorting_direction" value="increasing"/></div><div> </operator></div><div> <operator activated="true" class="generate_empty_attribute" compatibility="9.3.001" expanded="true" height="82" name="Generate Empty Attribute" width="90" x="45" y="187"></div><div> <parameter key="name" value="GraphNo"/></div><div> <parameter key="value_type" value="text"/></div><div> </operator></div><div> <operator activated="true" class="replace_missing_values" compatibility="9.3.001" expanded="true" height="103" name="Replace Missing Values" width="90" x="246" y="34"></div><div> <parameter key="return_preprocessing_model" value="false"/></div><div> <parameter key="create_view" value="false"/></div><div> <parameter key="attribute_filter_type" value="single"/></div><div> <parameter key="attribute" value="GraphNo"/></div><div> <parameter key="attributes" value="GraphNo"/></div><div> <parameter key="use_except_expression" value="false"/></div><div> <parameter key="value_type" value="attribute_value"/></div><div> <parameter key="use_value_type_exception" value="false"/></div><div> <parameter key="except_value_type" value="time"/></div><div> <parameter key="block_type" value="attribute_block"/></div><div> <parameter key="use_block_type_exception" value="false"/></div><div> <parameter key="except_block_type" value="value_matrix_row_start"/></div><div> <parameter key="invert_selection" value="false"/></div><div> <parameter key="include_special_attributes" value="false"/></div><div> <parameter key="default" value="value"/></div><div> <list key="columns"/></div><div> <parameter key="replenishment_value" value="G20181214L1MP11"/></div><div> </operator></div><div> <operator activated="true" class="select_attributes" compatibility="9.3.001" expanded="true" height="82" name="Select Attributes (2)" width="90" x="246" y="187"></div><div> <parameter key="attribute_filter_type" value="subset"/></div><div> <parameter key="attribute" value=""/></div><div> <parameter key="attributes" value="forecast of Temperature1|GraphNo|Last DateTime in window|Temperature1"/></div><div> <parameter key="use_except_expression" value="false"/></div><div> <parameter key="value_type" value="attribute_value"/></div><div> <parameter key="use_value_type_exception" value="false"/></div><div> <parameter key="except_value_type" value="time"/></div><div> <parameter key="block_type" value="attribute_block"/></div><div> <parameter key="use_block_type_exception" value="false"/></div><div> <parameter key="except_block_type" value="value_matrix_row_start"/></div><div> <parameter key="invert_selection" value="false"/></div><div> <parameter key="include_special_attributes" value="false"/></div><div> </operator></div><div> <operator activated="true" class="format_numbers" compatibility="9.3.001" expanded="true" height="82" name="Format Numbers" width="90" x="447" y="34"></div><div> <parameter key="attribute_filter_type" value="subset"/></div><div> <parameter key="attribute" value=""/></div><div> <parameter key="attributes" value="forecast of Temperature1"/></div><div> <parameter key="use_except_expression" value="false"/></div><div> <parameter key="value_type" value="numeric"/></div><div> <parameter key="use_value_type_exception" value="false"/></div><div> <parameter key="except_value_type" value="real"/></div><div> <parameter key="block_type" value="value_series"/></div><div> <parameter key="use_block_type_exception" value="false"/></div><div> <parameter key="except_block_type" value="value_series_end"/></div><div> <parameter key="invert_selection" value="false"/></div><div> <parameter key="include_special_attributes" value="true"/></div><div> <parameter key="format_type" value="number"/></div><div> <parameter key="pattern" value=".2"/></div><div> <parameter key="locale" value="English (United States)"/></div><div> <parameter key="use_grouping" value="false"/></div><div> </operator></div><div> <operator activated="false" class="generate_id" compatibility="9.3.001" expanded="true" height="82" name="Generate ID" width="90" x="447" y="187"></div><div> <parameter key="create_nominal_ids" value="false"/></div><div> <parameter key="offset" value="0"/></div><div> </operator></div><div> <connect from_port="in 1" to_op="Sort (2)" to_port="example set input"/></div><div> <connect from_op="Sort (2)" from_port="example set output" to_op="Generate Empty Attribute" to_port="example set input"/></div><div> <connect from_op="Generate Empty Attribute" from_port="example set output" to_op="Replace Missing Values" to_port="example set input"/></div><div> <connect from_op="Replace Missing Values" from_port="example set output" to_op="Select Attributes (2)" to_port="example set input"/></div><div> <connect from_op="Select Attributes (2)" from_port="example set output" to_op="Format Numbers" to_port="example set input"/></div><div> <connect from_op="Format Numbers" from_port="example set output" to_port="out 1"/></div><div> <portSpacing port="source_in 1" spacing="0"/></div><div> <portSpacing port="source_in 2" spacing="0"/></div><div> <portSpacing port="sink_out 1" spacing="0"/></div><div> <portSpacing port="sink_out 2" spacing="0"/></div><div> </process></div><div> </operator></div><div> <operator activated="false" class="store" compatibility="9.3.001" expanded="true" height="68" name="Example" width="90" x="112" y="238"></div><div> <parameter key="repository_entry" value="Lens From Database/ARIMA Example Oven Test MP2"/></div><div> </operator></div><div> <operator activated="false" class="store" compatibility="9.3.001" expanded="true" height="68" name="Dummy Performance" width="90" x="112" y="340"></div><div> <parameter key="repository_entry" value="Lens From Database/ARIMA Dummy Oven Test MP2"/></div><div> </operator></div><div> <operator activated="false" class="store" compatibility="9.3.001" expanded="true" height="68" name="ARIMA Performance" width="90" x="246" y="340"></div><div> <parameter key="repository_entry" value="Lens From Database/ARIMA Performance Oven Test MP2"/></div><div> </operator></div><div> <connect from_port="in 1" to_port="out 1"/></div><div> <connect from_port="in 2" to_op="Cross Validation" to_port="example set"/></div><div> <connect from_port="in 3" to_port="out 4"/></div><div> <connect from_op="Cross Validation" from_port="example set" to_op="Subprocess" to_port="in 1"/></div><div> <connect from_op="Cross Validation" from_port="test result set" to_port="out 5"/></div><div> <connect from_op="Cross Validation" from_port="performance 1" to_port="out 3"/></div><div> <connect from_op="Subprocess" from_port="out 1" to_port="out 2"/></div><div> <portSpacing port="source_in 1" spacing="0"/></div><div> <portSpacing port="source_in 2" spacing="0"/></div><div> <portSpacing port="source_in 3" spacing="0"/></div><div> <portSpacing port="source_in 4" spacing="0"/></div><div> <portSpacing port="sink_out 1" spacing="0"/></div><div> <portSpacing port="sink_out 2" spacing="0"/></div><div> <portSpacing port="sink_out 3" spacing="0"/></div><div> <portSpacing port="sink_out 4" spacing="0"/></div><div> <portSpacing port="sink_out 5" spacing="0"/></div><div> <portSpacing port="sink_out 6" spacing="0"/></div><div> </process></div><div> </operator></div><div> <operator activated="true" class="multiply" compatibility="9.3.001" expanded="true" height="103" name="Multiply" width="90" x="447" y="34"/></div><div> <operator activated="true" class="write_excel" compatibility="9.3.001" expanded="true" height="103" name="Write Excel" width="90" x="581" y="34"></div><div> <parameter key="excel_file" value="C:\Users\Protagonis Y410p\Desktop\GraphDataPredicted.xlsx"/></div><div> <parameter key="file_format" value="xlsx"/></div><div> <enumeration key="sheet_names"/></div><div> <parameter key="sheet_name" value="RapidMiner Data"/></div><div> <parameter key="date_format" value="yyyy-MM-dd HH:mm:ss"/></div><div> <parameter key="number_format" value="#.0"/></div><div> <parameter key="encoding" value="SYSTEM"/></div><div> </operator></div><div> <operator activated="true" class="read_excel" compatibility="9.3.001" expanded="true" height="68" name="Read Excel (2)" width="90" x="313" y="238"></div><div> <parameter key="excel_file" value="C:\Users\Protagonis Y410p\Desktop\GraphDataPredicted.xlsx"/></div><div> <parameter key="sheet_selection" value="sheet number"/></div><div> <parameter key="sheet_number" value="1"/></div><div> <parameter key="imported_cell_range" value="A1"/></div><div> <parameter key="encoding" value="SYSTEM"/></div><div> <parameter key="first_row_as_names" value="true"/></div><div> <list key="annotations"/></div><div> <parameter key="date_format" value=""/></div><div> <parameter key="time_zone" value="SYSTEM"/></div><div> <parameter key="locale" value="English (United States)"/></div><div> <parameter key="read_all_values_as_polynominal" value="false"/></div><div> <list key="data_set_meta_data_information"/></div><div> <parameter key="read_not_matching_values_as_missings" value="true"/></div><div> <parameter key="datamanagement" value="double_array"/></div><div> <parameter key="data_management" value="auto"/></div><div> </operator></div><div> <operator activated="true" class="append" compatibility="9.3.001" expanded="true" height="103" name="Append (2)" width="90" x="447" y="187"></div><div> <parameter key="datamanagement" value="double_array"/></div><div> <parameter key="data_management" value="auto"/></div><div> <parameter key="merge_type" value="all"/></div><div> </operator></div><div> <operator activated="true" class="write_excel" compatibility="9.3.001" expanded="true" height="103" name="Write Excel (2)" width="90" x="581" y="187"></div><div> <parameter key="excel_file" value="C:\Users\Protagonis Y410p\Desktop\GraphDataPredicted2.xlsx"/></div><div> <parameter key="file_format" value="xlsx"/></div><div> <enumeration key="sheet_names"/></div><div> <parameter key="sheet_name" value="RapidMiner Data"/></div><div> <parameter key="date_format" value="yyyy-MM-dd HH:mm:ss"/></div><div> <parameter key="number_format" value="#.0"/></div><div> <parameter key="encoding" value="SYSTEM"/></div><div> </operator></div><div> <operator activated="false" class="jdbc_connectors:write_database" compatibility="9.3.001" expanded="true" height="82" name="Write Database" width="90" x="313" y="340"></div><div> <parameter key="define_connection" value="predefined"/></div><div> <parameter key="connection_entry" value="//DB/Visco Lens/Example Sets/dbo.GraphData"/></div><div> <parameter key="connection" value="Visco Lens"/></div><div> <parameter key="database_system" value="MySQL"/></div><div> <parameter key="use_default_schema" value="true"/></div><div> <parameter key="table_name" value="GraphDataPredicted"/></div><div> <parameter key="overwrite_mode" value="overwrite first, append then"/></div><div> <parameter key="set_default_varchar_length" value="false"/></div><div> <parameter key="default_varchar_length" value="128"/></div><div> <parameter key="add_generated_primary_keys" value="false"/></div><div> <parameter key="db_key_attribute_name" value="DateTime"/></div><div> <parameter key="batch_size" value="0"/></div><div> </operator></div><div> <operator activated="false" class="jdbc_connectors:update_database" compatibility="9.3.001" expanded="true" height="82" name="Update Database" width="90" x="179" y="340"></div><div> <parameter key="define_connection" value="predefined"/></div><div> <parameter key="connection" value="Visco Lens"/></div><div> <parameter key="database_system" value="MySQL"/></div><div> <parameter key="use_default_schema" value="true"/></div><div> <parameter key="table_name" value="GraphDataPredicted"/></div><div> <parameter key="attribute_filter_type" value="all"/></div><div> <parameter key="attribute" value=""/></div><div> <parameter key="attributes" value=""/></div><div> <parameter key="use_except_expression" value="false"/></div><div> <parameter key="value_type" value="attribute_value"/></div><div> <parameter key="use_value_type_exception" value="false"/></div><div> <parameter key="except_value_type" value="time"/></div><div> <parameter key="block_type" value="attribute_block"/></div><div> <parameter key="use_block_type_exception" value="false"/></div><div> <parameter key="except_block_type" value="value_matrix_row_start"/></div><div> <parameter key="invert_selection" value="false"/></div><div> <parameter key="include_special_attributes" value="true"/></div><div> </operator></div><div> <operator activated="false" class="subprocess" compatibility="9.3.001" expanded="true" height="68" name="Subprocess (3)" width="90" x="45" y="340"></div><div> <process expanded="true"></div><div> <operator activated="false" class="store" compatibility="9.3.001" expanded="true" height="68" name="Forecast" width="90" x="179" y="34"></div><div> <parameter key="repository_entry" value="Lens From Database/ARIMA Forecast Oven Test MP2"/></div><div> </operator></div><div> <operator activated="false" class="store" compatibility="9.3.001" expanded="true" height="68" name="Model" width="90" x="179" y="136"></div><div> <parameter key="repository_entry" value="Lens From Database/ARIMA Model Oven Test MP2"/></div><div> </operator></div><div> <operator activated="false" class="time_series:apply_forecast" compatibility="9.3.001" expanded="true" height="82" name="Apply Forecast" width="90" x="45" y="136"></div><div> <parameter key="forecast_horizon" value="5"/></div><div> <parameter key="add_original_time_series" value="true"/></div><div> <parameter key="add_combined_time_series" value="true"/></div><div> </operator></div><div> <portSpacing port="source_in 1" spacing="0"/></div><div> <portSpacing port="sink_out 1" spacing="0"/></div><div> </process></div><div> </operator></div><div> <connect from_op="Read Database" from_port="output" to_op="Select Attributes" to_port="example set input"/></div><div> <connect from_op="Select Attributes" from_port="example set output" to_op="Set Role" to_port="example set input"/></div><div> <connect from_op="Set Role" from_port="example set output" to_op="Forecast Validation" to_port="example set"/></div><div> <connect from_op="Forecast Validation" from_port="model" to_op="Dummy Machine Learning" to_port="in 1"/></div><div> <connect from_op="Forecast Validation" from_port="test result set" to_op="Dummy Machine Learning" to_port="in 2"/></div><div> <connect from_op="Forecast Validation" from_port="performance 1" to_op="Dummy Machine Learning" to_port="in 3"/></div><div> <connect from_op="Dummy Machine Learning" from_port="out 2" to_op="Multiply" to_port="input"/></div><div> <connect from_op="Multiply" from_port="output 1" to_op="Write Excel" to_port="input"/></div><div> <connect from_op="Multiply" from_port="output 2" to_op="Append (2)" to_port="example set 1"/></div><div> <connect from_op="Write Excel" from_port="through" to_port="result 1"/></div><div> <connect from_op="Read Excel (2)" from_port="output" to_op="Append (2)" to_port="example set 2"/></div><div> <connect from_op="Append (2)" from_port="merged set" to_op="Write Excel (2)" to_port="input"/></div><div> <connect from_op="Write Excel (2)" from_port="through" to_port="result 2"/></div><div> <portSpacing port="source_input 1" spacing="0"/></div><div> <portSpacing port="sink_result 1" spacing="0"/></div><div> <portSpacing port="sink_result 2" spacing="0"/></div><div> <portSpacing port="sink_result 3" spacing="0"/></div><div> </process></div><div> </operator></div><div></process></div>
Tagged:
0
Best Answer
-
Hi,a quick fix would maybe be to use Append (SuperSet) from Operator Toolbox and not the normal Append.BR,Martin2
Altair EmployeeAnswers
-
Hi,a quick fix would maybe be to use Append (SuperSet) from Operator Toolbox and not the normal Append.BR,Martin2
-
Thanks, it work.
Sometimes the answer it just in front our eyes, we just don't notice it. haha...1