File extension of log file

ivangfalconiivangfalconi Member Posts: 3 Contributor I
edited November 2018 in Help
<?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
<operator activated="true" class="write_csv" compatibility="8.0.001" expanded="true" height="82" name="Write CSV" width="90" x="45" y="289">
<parameter key="csv_file" value="problema"/>
<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>
</process>

Hi. Need help, please. Error message: "No log data table available".  First, I named log file differently from the dataset (in "Create Log Data" operator) and creted a new folder for it. "Log" operator requests the path of folder. Did not work so I named log file with same name of dataset. Did not work either. What extension file should log file be?       PM1.pngPM2.pngPM3.pngPM4.png

Tagged:

Best Answers

  • lionelderkrikorlionelderkrikor Posts: 716   Unicorn
    Solution Accepted

    Hi @ivangfalconi,

     

    The XML process, you provided, is incomplete : It can be loaded.

    Moreover we don't know what is your label attribute.

    In view of the screenshots, you used the "predictive maintenance " process template.

     

    Can you please share your whole process ?

     

    Regards, 

     

     

    Lionel

     

  • ivangfalconiivangfalconi Posts: 3 Contributor I
    Solution Accepted
    <?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
    <operator activated="true" class="write_csv" compatibility="8.0.001" expanded="true" height="82" name="Write CSV" width="90" x="45" y="238">
    <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>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
    <operator activated="true" class="write_csv" compatibility="8.0.001" expanded="true" height="82" name="Write CSV" width="90" x="380" y="442">
    <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>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
    <operator activated="true" class="write_csv" compatibility="8.0.001" expanded="true" height="82" name="Write CSV" width="90" x="380" y="391">
    <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>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
    <operator activated="true" class="write_csv" compatibility="8.0.001" expanded="true" height="82" name="Write CSV" width="90" x="380" y="391">
    <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>
    </process>

    Thank you for your quick reply and apologize for my late reply. I am not sure if what I copied - complete process - is OK. It resembles the previous process already posted.  In order to copy process for 1st part, I followed instructions from video. For remaining subprocesses I connected the write operator to the last operator. Is this correct?

    And yes, ii is basically same model posted in the tab menu "Learn" except that I added a "Dicretize" operator in one of the Subprocesses.

  • lionelderkrikorlionelderkrikor Posts: 716   Unicorn
    Solution Accepted

    Hi @ivangfalconi,

     

    It seems you are not using the good method to share your process : 

    You have just to follow these 2 steps : 

    1. Copy your XML code  : 

    Predicitive_maintenance_1.png58858

    2. Paste your XML code in the Insert Code pop up window then click "OK"

    Predicitive_maintenance_2.png5855

     

    3. That's it ! 

     

    I hope it helps,

     

    Regards, 

     

    Lionel

     

Answers

  • ivangfalconiivangfalconi Member Posts: 3 Contributor I
    <?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
    <context>
    <input/>
    <output/>
    <macros>
    <macro>
    <key>label</key>
    <value>Failure</value>
    </macro>
    <macro>
    <key>label_positive_class</key>
    <value>yes</value>
    </macro>
    <macro>
    <key>label_negative_class</key>
    <value>no</value>
    </macro>
    </macros>
    </context>
    <operator activated="true" class="process" compatibility="8.0.001" expanded="true" name="Process">
    <process expanded="true">
    <operator activated="true" class="retrieve" compatibility="8.0.001" expanded="true" height="68" name="Load Reference Data" width="90" x="45" y="136">
    <parameter key="repository_entry" value="../data/trainmecanica"/>
    <description align="left" color="blue" colored="true" width="126">Step 1:&lt;br/&gt;Load data of past machine runs, labeled with information about whether there has been a failure or not.</description>
    </operator>
    <operator activated="true" class="set_role" compatibility="8.0.001" expanded="true" height="82" name="Set Role (2)" width="90" x="179" y="136">
    <parameter key="attribute_name" value="V2"/>
    <parameter key="target_role" value="label"/>
    <list key="set_additional_roles">
    <parameter key="V1" value="label"/>
    <parameter key="V10" value="label"/>
    <parameter key="V12" value="label"/>
    <parameter key="V11" value="label"/>
    <parameter key="V13" value="label"/>
    <parameter key="V14" value="label"/>
    <parameter key="V15" value="label"/>
    <parameter key="V16" value="label"/>
    <parameter key="V2" value="label"/>
    <parameter key="V3" value="label"/>
    <parameter key="V4" value="label"/>
    <parameter key="V5" value="label"/>
    <parameter key="V6" value="label"/>
    <parameter key="V7" value="label"/>
    <parameter key="V8" value="label"/>
    <parameter key="V9" value="label"/>
    </list>
    </operator>
    <operator activated="true" class="select_attributes" compatibility="8.0.001" expanded="true" height="82" name="Select Attributes" width="90" x="179" y="238">
    <parameter key="attributes" value="V9|V1|V10|V11|V12|V13|V14|V15|V16|V17|V18|V2|V3|V4|V5|V6|V7|V8"/>
    <parameter key="value_type" value="integer"/>
    </operator>
    <operator activated="true" class="multiply" compatibility="8.0.001" expanded="true" height="82" name="Multiply data" width="90" x="313" y="238"/>
    <operator activated="true" class="subprocess" compatibility="8.0.001" expanded="true" height="82" name="Determine Influence Factors" width="90" x="447" y="187">
    <process expanded="true">
    <operator activated="true" class="weight_by_correlation" compatibility="8.0.001" expanded="true" height="82" name="Weight by Correlation" width="90" x="45" y="34"/>
    <operator activated="true" class="discretize_by_bins" compatibility="8.0.001" expanded="true" height="103" name="Discretize" width="90" x="45" y="136">
    <parameter key="create_view" value="true"/>
    <parameter key="attributes" value="V1|V11|V10|V12|V13|V14|V18|V17|V16|V15|V4|V3|V2|V6|V5|V7|V8|V9"/>
    <parameter key="value_type" value="real"/>
    <parameter key="include_special_attributes" value="true"/>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="8.0.001" expanded="true" height="68" name="Weights to Data" width="90" x="179" y="30"/>
    <operator activated="true" class="generate_attributes" compatibility="6.4.000" expanded="true" height="82" name="Generate Attributes (2)" width="90" x="313" y="30">
    <list key="function_descriptions">
    <parameter key="Method" value="&quot;Correlation&quot;"/>
    </list>
    </operator>
    <operator activated="true" class="weight_by_gini_index" compatibility="8.0.001" expanded="true" height="82" name="Weight by Gini Index" width="90" x="45" y="238"/>
    <operator activated="true" class="weight_by_information_gain" compatibility="8.0.001" expanded="true" height="82" name="Weight by Information Gain" width="90" x="45" y="340"/>
    <operator activated="true" class="weight_by_information_gain_ratio" compatibility="8.0.001" expanded="true" height="82" name="Weight by Information Gain Ratio" width="90" x="45" y="442"/>
    <operator activated="true" class="weights_to_data" compatibility="8.0.001" expanded="true" height="68" name="Weights to Data (2)" width="90" x="179" y="120"/>
    <operator activated="true" class="generate_attributes" compatibility="8.0.001" expanded="true" height="82" name="Generate Attributes (3)" width="90" x="313" y="120">
    <list key="function_descriptions">
    <parameter key="Method" value="&quot;Gini&quot;"/>
    </list>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="8.0.001" expanded="true" height="68" name="Weights to Data (3)" width="90" x="179" y="210"/>
    <operator activated="true" class="generate_attributes" compatibility="8.0.001" expanded="true" height="82" name="Generate Attributes (4)" width="90" x="313" y="210">
    <list key="function_descriptions">
    <parameter key="Method" value="&quot;InfoGain&quot;"/>
    </list>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="8.0.001" expanded="true" height="68" name="Weights to Data (4)" width="90" x="179" y="300"/>
    <operator activated="true" class="generate_attributes" compatibility="8.0.001" expanded="true" height="82" name="Generate Attributes (5)" width="90" x="313" y="300">
    <list key="function_descriptions">
    <parameter key="Method" value="&quot;InfoGainRatio&quot;"/>
    </list>
    </operator>
    <operator activated="true" class="append" compatibility="8.0.001" expanded="true" height="145" name="Append" width="90" x="447" y="30"/>
    <operator activated="true" class="pivot" compatibility="8.0.001" expanded="true" height="82" name="Pivot" width="90" x="581" y="30">
    <parameter key="group_attribute" value="Attribute"/>
    <parameter key="index_attribute" value="Method"/>
    </operator>
    <operator activated="true" class="generate_aggregation" compatibility="8.0.001" expanded="true" height="82" name="Generate Aggregation" width="90" x="715" y="30">
    <parameter key="attribute_name" value="Importance"/>
    <parameter key="attribute_filter_type" value="value_type"/>
    <parameter key="value_type" value="numeric"/>
    <parameter key="aggregation_function" value="average"/>
    </operator>
    <operator activated="true" class="normalize" compatibility="7.5.003" expanded="true" height="103" name="Normalize" width="90" x="849" y="238">
    <parameter key="attribute_filter_type" value="single"/>
    <parameter key="attribute" value="Importance"/>
    <parameter key="method" value="range transformation"/>
    </operator>
    <operator activated="true" class="sort" compatibility="8.0.001" expanded="true" height="82" name="Sort (2)" width="90" x="581" y="120">
    <parameter key="attribute_name" value="Importance"/>
    <parameter key="sorting_direction" value="decreasing"/>
    </operator>
    <operator activated="true" class="order_attributes" compatibility="8.0.001" expanded="true" height="82" name="Reorder Attributes (3)" width="90" x="715" y="187">
    <parameter key="attribute_ordering" value="Attribute|Importance"/>
    <parameter key="handle_unmatched" value="remove"/>
    </operator>
    <connect from_port="in 1" to_op="Weight by Correlation" to_port="example set"/>
    <connect from_op="Weight by Correlation" from_port="weights" to_op="Weights to Data" to_port="attribute weights"/>
    <connect from_op="Weight by Correlation" from_port="example set" to_op="Discretize" to_port="example set input"/>
    <connect from_op="Discretize" from_port="example set output" to_op="Weight by Gini Index" to_port="example set"/>
    <connect from_op="Weights to Data" from_port="example set" to_op="Generate Attributes (2)" to_port="example set input"/>
    <connect from_op="Generate Attributes (2)" from_port="example set output" to_op="Append" to_port="example set 1"/>
    <connect from_op="Weight by Gini Index" from_port="weights" to_op="Weights to Data (2)" to_port="attribute weights"/>
    <connect from_op="Weight by Gini Index" from_port="example set" to_op="Weight by Information Gain" to_port="example set"/>
    <connect from_op="Weight by Information Gain" from_port="weights" to_op="Weights to Data (3)" to_port="attribute weights"/>
    <connect from_op="Weight by Information Gain" from_port="example set" to_op="Weight by Information Gain Ratio" to_port="example set"/>
    <connect from_op="Weight by Information Gain Ratio" from_port="weights" to_op="Weights to Data (4)" to_port="attribute weights"/>
    <connect from_op="Weights to Data (2)" from_port="example set" to_op="Generate Attributes (3)" to_port="example set input"/>
    <connect from_op="Generate Attributes (3)" from_port="example set output" to_op="Append" to_port="example set 2"/>
    <connect from_op="Weights to Data (3)" from_port="example set" to_op="Generate Attributes (4)" to_port="example set input"/>
    <connect from_op="Generate Attributes (4)" from_port="example set output" to_op="Append" to_port="example set 3"/>
    <connect from_op="Weights to Data (4)" from_port="example set" to_op="Generate Attributes (5)" to_port="example set input"/>
    <connect from_op="Generate Attributes (5)" from_port="example set output" to_op="Append" to_port="example set 4"/>
    <connect from_op="Append" from_port="merged set" to_op="Pivot" to_port="example set input"/>
    <connect from_op="Pivot" from_port="example set output" to_op="Generate Aggregation" to_port="example set input"/>
    <connect from_op="Generate Aggregation" from_port="example set output" to_op="Normalize" to_port="example set input"/>
    <connect from_op="Normalize" from_port="example set output" to_op="Sort (2)" to_port="example set input"/>
    <connect from_op="Sort (2)" from_port="example set output" to_op="Reorder Attributes (3)" to_port="example set input"/>
    <connect from_op="Reorder Attributes (3)" from_port="example set output" to_port="out 1"/>
    <portSpacing port="source_in 1" spacing="0"/>
    <portSpacing port="source_in 2" spacing="0"/>
    <portSpacing port="sink_out 1" spacing="0"/>
    <portSpacing port="sink_out 2" spacing="0"/>
    </process>
    </operator>
    <operator activated="true" class="retrieve" compatibility="8.0.001" expanded="true" height="68" name="Load New Data" width="90" x="380" y="493">
    <parameter key="repository_entry" value="../data/testmecanica"/>
    </operator>
    <operator activated="true" class="select_attributes" compatibility="8.0.001" expanded="true" height="82" name="Select Attributes (2)" width="90" x="514" y="493">
    <parameter key="attributes" value="V1|V10|V11|V12|V13|V14|V15|V16|V17|V18|V2|V3|V4|V5|V6|V7|V8|V9"/>
    </operator>
    <operator activated="true" class="optimize_parameters_grid" compatibility="8.0.001" expanded="true" height="124" name="Optimize Model" width="90" x="45" y="391">
    <list key="parameters">
    <parameter key="k-NN.k" value="[1.0;50;49;linear]"/>
    </list>
    <process expanded="true">
    <operator activated="true" class="concurrency:cross_validation" compatibility="8.0.001" expanded="true" height="145" name="Validate model" width="90" x="45" y="34">
    <parameter key="sampling_type" value="linear sampling"/>
    <process expanded="true">
    <operator activated="true" class="set_role" compatibility="8.0.001" expanded="true" height="82" name="Set Role" width="90" x="45" y="34">
    <parameter key="attribute_name" value="V1"/>
    <list key="set_additional_roles">
    <parameter key="V1" value="label"/>
    <parameter key="V10" value="label"/>
    <parameter key="V11" value="label"/>
    <parameter key="V12" value="label"/>
    <parameter key="V13" value="label"/>
    <parameter key="V14" value="label"/>
    <parameter key="V15" value="label"/>
    <parameter key="V16" value="label"/>
    <parameter key="V2" value="label"/>
    <parameter key="V3" value="label"/>
    <parameter key="V4" value="label"/>
    <parameter key="V5" value="label"/>
    <parameter key="V6" value="label"/>
    <parameter key="V7" value="label"/>
    <parameter key="V8" value="label"/>
    <parameter key="V9" value="label"/>
    </list>
    </operator>
    <operator activated="true" class="k_nn" compatibility="8.0.001" expanded="true" height="82" name="k-NN" width="90" x="179" y="34">
    <parameter key="k" value="44"/>
    <parameter key="measure_types" value="NumericalMeasures"/>
    <parameter key="numerical_measure" value="KernelEuclideanDistance"/>
    <parameter key="kernel_type" value="epanechnikov"/>
    </operator>
    <connect from_port="training set" to_op="Set Role" to_port="example set input"/>
    <connect from_op="Set Role" from_port="example set output" to_op="k-NN" to_port="training set"/>
    <connect from_op="k-NN" from_port="model" to_port="model"/>
    <portSpacing port="source_training set" spacing="0"/>
    <portSpacing port="sink_model" spacing="0"/>
    <portSpacing port="sink_through 1" spacing="0"/>
    </process>
    <process expanded="true">
    <operator activated="true" class="apply_model" compatibility="8.0.001" expanded="true" height="82" name="Apply model" width="90" x="45" y="34">
    <list key="application_parameters"/>
    </operator>
    <operator activated="true" class="performance" compatibility="8.0.001" expanded="true" height="82" name="Performance" width="90" x="179" y="34"/>
    <connect from_port="model" to_op="Apply model" to_port="model"/>
    <connect from_port="test set" to_op="Apply model" to_port="unlabelled data"/>
    <connect from_op="Apply model" from_port="labelled data" to_op="Performance" to_port="labelled data"/>
    <connect from_op="Performance" from_port="performance" to_port="performance 1"/>
    <portSpacing port="source_model" spacing="0"/>
    <portSpacing port="source_test set" spacing="0"/>
    <portSpacing port="source_through 1" spacing="0"/>
    <portSpacing port="sink_test set results" spacing="0"/>
    <portSpacing port="sink_performance 1" spacing="0"/>
    <portSpacing port="sink_performance 2" spacing="0"/>
    </process>
    </operator>
    <operator activated="true" class="log" compatibility="8.0.001" expanded="true" height="82" name="Log model performance" width="90" x="246" y="136">
    <parameter key="filename" value="C:\Users\personal\Documents\logmodelperformance.log"/>
    <list key="log">
    <parameter key="k" value="operator.k-NN.parameter.k"/>
    <parameter key="Accuracy" value="operator.Validate model.value.performance main criterion"/>
    <parameter key="Standard Deviation" value="operator.Validate model.value.std deviation main criterion"/>
    </list>
    </operator>
    <connect from_port="input 1" to_op="Validate model" to_port="example set"/>
    <connect from_op="Validate model" from_port="model" to_port="result 1"/>
    <connect from_op="Validate model" from_port="performance 1" to_op="Log model performance" to_port="through 1"/>
    <connect from_op="Log model performance" from_port="through 1" to_port="performance"/>
    <portSpacing port="source_input 1" spacing="0"/>
    <portSpacing port="source_input 2" spacing="0"/>
    <portSpacing port="sink_performance" spacing="0"/>
    <portSpacing port="sink_result 1" spacing="0"/>
    <portSpacing port="sink_result 2" spacing="0"/>
    </process>
    </operator>
    <operator activated="true" class="log_to_data" compatibility="8.0.001" expanded="true" height="103" name="Create Log Data" width="90" x="179" y="340">
    <parameter key="log_name" value="falla.txt"/>
    </operator>
    <operator activated="true" class="log" compatibility="8.0.001" expanded="true" height="82" name="Log" width="90" x="380" y="340">
    <parameter key="filename" value="C:\\Users\personal\.RapidMiner\falla\falla.txt"/>
    <list key="log">
    <parameter key="V1" value="operator.Log.value."/>
    <parameter key="V2" value="operator.Log.value."/>
    <parameter key="V3" value="operator.Log.value."/>
    <parameter key="V4" value="operator.Log.value."/>
    <parameter key="V5" value="operator.Log.value."/>
    <parameter key="V6" value="operator.Log.value."/>
    <parameter key="V7" value="operator.Log.value."/>
    <parameter key="V8" value="operator.Log.value."/>
    <parameter key="V9" value="operator.Log.value.applycount"/>
    <parameter key="V10" value="operator.Log.value."/>
    <parameter key="V11" value="operator.Log.value."/>
    <parameter key="V12" value="operator.Log.value."/>
    <parameter key="V13" value="operator.Log.value."/>
    <parameter key="V14" value="operator.Log.value."/>
    <parameter key="V15" value="operator.Log.value."/>
    <parameter key="V16" value="operator.Log.value."/>
    </list>
    </operator>
    <operator activated="true" class="apply_model" compatibility="8.0.001" expanded="true" height="82" name="Score New Data" width="90" x="581" y="391">
    <list key="application_parameters"/>
    </operator>
    <operator activated="true" class="subprocess" compatibility="8.0.001" expanded="true" height="82" name="Postprocess Scores" width="90" x="715" y="340">
    <process expanded="true">
    <operator activated="true" class="sort" compatibility="8.0.001" expanded="true" height="82" name="Sort" width="90" x="45" y="34">
    <parameter key="attribute_name" value="confidence(yes)"/>
    <parameter key="sorting_direction" value="decreasing"/>
    </operator>
    <operator activated="true" class="select_attributes" compatibility="8.0.001" expanded="true" height="82" name="Remove columns" width="90" x="179" y="34">
    <parameter key="invert_selection" value="true"/>
    </operator>
    <connect from_port="in 1" to_op="Sort" to_port="example set input"/>
    <connect from_op="Sort" from_port="example set output" to_op="Remove columns" to_port="example set input"/>
    <connect from_op="Remove columns" from_port="example set output" to_port="out 1"/>
    <portSpacing port="source_in 1" spacing="0"/>
    <portSpacing port="source_in 2" spacing="0"/>
    <portSpacing port="sink_out 1" spacing="0"/>
    <portSpacing port="sink_out 2" spacing="0"/>
    </process>
    </operator>
    <connect from_op="Load Reference Data" from_port="output" to_op="Set Role (2)" to_port="example set input"/>
    <connect from_op="Set Role (2)" from_port="example set output" to_op="Select Attributes" to_port="example set input"/>
    <connect from_op="Select Attributes" from_port="example set output" to_op="Multiply data" to_port="input"/>
    <connect from_op="Select Attributes" from_port="original" to_op="Optimize Model" to_port="input 1"/>
    <connect from_op="Multiply data" from_port="output 1" to_op="Determine Influence Factors" to_port="in 1"/>
    <connect from_op="Determine Influence Factors" from_port="out 1" to_port="result 1"/>
    <connect from_op="Load New Data" from_port="output" to_op="Select Attributes (2)" to_port="example set input"/>
    <connect from_op="Select Attributes (2)" from_port="example set output" to_op="Score New Data" to_port="unlabelled data"/>
    <connect from_op="Optimize Model" from_port="performance" to_op="Create Log Data" to_port="through 1"/>
    <connect from_op="Optimize Model" from_port="result 1" to_op="Score New Data" to_port="model"/>
    <connect from_op="Create Log Data" from_port="exampleSet" to_op="Log" to_port="through 1"/>
    <connect from_op="Log" from_port="through 1" to_port="result 2"/>
    <connect from_op="Score New Data" from_port="labelled data" to_op="Postprocess Scores" to_port="in 1"/>
    <connect from_op="Postprocess Scores" from_port="out 1" to_port="result 3"/>
    <portSpacing port="source_input 1" spacing="0"/>
    <portSpacing port="sink_result 1" spacing="0"/>
    <portSpacing port="sink_result 2" spacing="0"/>
    <portSpacing port="sink_result 3" spacing="0"/>
    <portSpacing port="sink_result 4" spacing="0"/>
    <description align="left" color="green" colored="true" height="300" resized="true" width="320" x="20" y="330">&lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; Step 3:&lt;br&gt;Train a k-NN model - optimizing for k (the number of reference situations to take into account for prediction) to produce a maximum failure prediction accuracy.</description>
    <description align="left" color="yellow" colored="false" height="70" resized="true" width="850" x="20" y="25">PREDICTIVE MAINTENANCE&lt;br&gt;Model equipment failures based on data referencing observations of past machine runs and failures. Apply model to current situations to anticipate machine failures and schedule maintenance pre-emptively.</description>
    <description align="left" color="purple" colored="true" height="215" resized="true" width="520" x="350" y="105">Step 2:&lt;br/&gt;Determine influence factors using various attribute weighting algorithms and averaging their weights results.</description>
    <description align="left" color="green" colored="true" height="300" resized="true" width="520" x="350" y="330">&lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; Step 4:&lt;br/&gt;Load new data and apply the machine failure model to current machine runs to predict potential machine failures.&lt;br&gt;</description>
    <description align="left" color="yellow" colored="false" height="35" resized="false" width="850" x="20" y="640">Outputs: influence factors, k-NN optimization log, failure predictions</description>
    </process>
    </operator>
    </process>
  • lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, Member Posts: 716   Unicorn

    Hi again @ivangfalconi,

     

    1. Log data table error.

     

    I fix this error : You have to set the name of a Log operator. In your case, I choose the "Log model performance" Log operator which

    is inside your Optimize Parameters operator.

     

    2. Your process

    After taking a look to your performance results, (accuracy = 0 and std deviation = 0 for all combinaisons of parameters), there are corrections to perform in your process. In a "classic" data-science project, you have to : 

     - Set a single attribute as label in your Set Role operator. (In your Set Role operator, all attributes are set as label).The label is the variable you want to predict.

    - In a "classic" predictive maintenance project, the label is binary (failure / no failure). In your case, the V2 attribute can not a priori be a label without preprocessing, because it can take many values (integer type). It's an hypothesis, if this attribute is effectively the label , but you can apply it the Numerical to Binominal operator : below a threshold ==> failure / above a threshold => no failure (or vice-versa).

     - All the other attributes have to be set as regular attribute in your Set Role operator. These attributes are the explicative variables. The model that you train establishes the relationships between these explicative variables and your label attribute.

    - Delete the Set Role operator inside the Validation operator : You have to set the roles once.

     

    Here the process : 

    NB : I disabled the "score branch" of your process because I have not your score dataset.

    <?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
    <context>
    <input/>
    <output/>
    <macros>
    <macro>
    <key>label</key>
    <value>Failure</value>
    </macro>
    <macro>
    <key>label_positive_class</key>
    <value>yes</value>
    </macro>
    <macro>
    <key>label_negative_class</key>
    <value>no</value>
    </macro>
    </macros>
    </context>
    <operator activated="true" class="process" compatibility="8.0.001" expanded="true" name="Process">
    <process expanded="true">
    <operator activated="false" class="retrieve" compatibility="8.0.001" expanded="true" height="68" name="Load New Data" width="90" x="380" y="493">
    <parameter key="repository_entry" value="../data/testmecanica"/>
    </operator>
    <operator activated="false" class="select_attributes" compatibility="8.0.001" expanded="true" height="82" name="Select Attributes (2)" width="90" x="514" y="493">
    <parameter key="attributes" value="V1|V10|V11|V12|V13|V14|V15|V16|V17|V18|V2|V3|V4|V5|V6|V7|V8|V9"/>
    </operator>
    <operator activated="true" breakpoints="after" class="read_csv" compatibility="8.0.001" expanded="true" height="68" name="Read CSV" width="90" x="45" y="136">
    <parameter key="csv_file" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\Predictive maintenance\trainmecanica.csv"/>
    <parameter key="column_separators" value=","/>
    <parameter key="first_row_as_names" value="false"/>
    <list key="annotations">
    <parameter key="0" value="Name"/>
    </list>
    <parameter key="encoding" value="windows-1252"/>
    <list key="data_set_meta_data_information">
    <parameter key="0" value="att1.true.integer.attribute"/>
    <parameter key="1" value="V1.true.real.attribute"/>
    <parameter key="2" value="V2.true.integer.attribute"/>
    <parameter key="3" value="V3.true.real.attribute"/>
    <parameter key="4" value="V4.true.real.attribute"/>
    <parameter key="5" value="V5.true.real.attribute"/>
    <parameter key="6" value="V6.true.real.attribute"/>
    <parameter key="7" value="V7.true.real.attribute"/>
    <parameter key="8" value="V8.true.real.attribute"/>
    <parameter key="9" value="V9.true.integer.attribute"/>
    <parameter key="10" value="V10.true.real.attribute"/>
    <parameter key="11" value="V11.true.real.attribute"/>
    <parameter key="12" value="V12.true.real.attribute"/>
    <parameter key="13" value="V13.true.real.attribute"/>
    <parameter key="14" value="V14.true.real.attribute"/>
    <parameter key="15" value="V15.true.real.attribute"/>
    <parameter key="16" value="V16.true.real.attribute"/>
    <parameter key="17" value="V17.true.real.attribute"/>
    <parameter key="18" value="V18.true.real.attribute"/>
    </list>
    </operator>
    <operator activated="true" class="set_role" compatibility="8.0.001" expanded="true" height="82" name="Set Role (2)" width="90" x="179" y="136">
    <parameter key="attribute_name" value="V2"/>
    <parameter key="target_role" value="label"/>
    <list key="set_additional_roles">
    <parameter key="V1" value="label"/>
    <parameter key="V10" value="label"/>
    <parameter key="V12" value="label"/>
    <parameter key="V11" value="label"/>
    <parameter key="V13" value="label"/>
    <parameter key="V14" value="label"/>
    <parameter key="V15" value="label"/>
    <parameter key="V16" value="label"/>
    <parameter key="V2" value="label"/>
    <parameter key="V3" value="label"/>
    <parameter key="V4" value="label"/>
    <parameter key="V5" value="label"/>
    <parameter key="V6" value="label"/>
    <parameter key="V7" value="label"/>
    <parameter key="V8" value="label"/>
    <parameter key="V9" value="label"/>
    </list>
    </operator>
    <operator activated="true" class="select_attributes" compatibility="8.0.001" expanded="true" height="82" name="Select Attributes" width="90" x="179" y="238">
    <parameter key="attributes" value="V9|V1|V10|V11|V12|V13|V14|V15|V16|V17|V18|V2|V3|V4|V5|V6|V7|V8"/>
    <parameter key="value_type" value="integer"/>
    </operator>
    <operator activated="true" class="multiply" compatibility="8.0.001" expanded="true" height="82" name="Multiply data" width="90" x="313" y="238"/>
    <operator activated="true" class="subprocess" compatibility="8.0.001" expanded="true" height="82" name="Determine Influence Factors" width="90" x="447" y="187">
    <process expanded="true">
    <operator activated="true" class="weight_by_correlation" compatibility="8.0.001" expanded="true" height="82" name="Weight by Correlation" width="90" x="45" y="34"/>
    <operator activated="true" class="discretize_by_bins" compatibility="8.0.001" expanded="true" height="103" name="Discretize" width="90" x="45" y="136">
    <parameter key="create_view" value="true"/>
    <parameter key="attributes" value="V1|V11|V10|V12|V13|V14|V18|V17|V16|V15|V4|V3|V2|V6|V5|V7|V8|V9"/>
    <parameter key="value_type" value="real"/>
    <parameter key="include_special_attributes" value="true"/>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="8.0.001" expanded="true" height="68" name="Weights to Data" width="90" x="179" y="30"/>
    <operator activated="true" class="generate_attributes" compatibility="6.4.000" expanded="true" height="82" name="Generate Attributes (2)" width="90" x="313" y="30">
    <list key="function_descriptions">
    <parameter key="Method" value="&quot;Correlation&quot;"/>
    </list>
    </operator>
    <operator activated="true" class="weight_by_gini_index" compatibility="8.0.001" expanded="true" height="82" name="Weight by Gini Index" width="90" x="45" y="238"/>
    <operator activated="true" class="weight_by_information_gain" compatibility="8.0.001" expanded="true" height="82" name="Weight by Information Gain" width="90" x="45" y="340"/>
    <operator activated="true" class="weight_by_information_gain_ratio" compatibility="8.0.001" expanded="true" height="82" name="Weight by Information Gain Ratio" width="90" x="45" y="442"/>
    <operator activated="true" class="weights_to_data" compatibility="8.0.001" expanded="true" height="68" name="Weights to Data (2)" width="90" x="179" y="120"/>
    <operator activated="true" class="generate_attributes" compatibility="8.0.001" expanded="true" height="82" name="Generate Attributes (3)" width="90" x="313" y="120">
    <list key="function_descriptions">
    <parameter key="Method" value="&quot;Gini&quot;"/>
    </list>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="8.0.001" expanded="true" height="68" name="Weights to Data (3)" width="90" x="179" y="210"/>
    <operator activated="true" class="generate_attributes" compatibility="8.0.001" expanded="true" height="82" name="Generate Attributes (4)" width="90" x="313" y="210">
    <list key="function_descriptions">
    <parameter key="Method" value="&quot;InfoGain&quot;"/>
    </list>
    </operator>
    <operator activated="true" class="weights_to_data" compatibility="8.0.001" expanded="true" height="68" name="Weights to Data (4)" width="90" x="179" y="300"/>
    <operator activated="true" class="generate_attributes" compatibility="8.0.001" expanded="true" height="82" name="Generate Attributes (5)" width="90" x="313" y="300">
    <list key="function_descriptions">
    <parameter key="Method" value="&quot;InfoGainRatio&quot;"/>
    </list>
    </operator>
    <operator activated="true" class="append" compatibility="8.0.001" expanded="true" height="145" name="Append" width="90" x="447" y="30"/>
    <operator activated="true" class="pivot" compatibility="8.0.001" expanded="true" height="82" name="Pivot" width="90" x="581" y="30">
    <parameter key="group_attribute" value="Attribute"/>
    <parameter key="index_attribute" value="Method"/>
    </operator>
    <operator activated="true" class="generate_aggregation" compatibility="8.0.001" expanded="true" height="82" name="Generate Aggregation" width="90" x="715" y="30">
    <parameter key="attribute_name" value="Importance"/>
    <parameter key="attribute_filter_type" value="value_type"/>
    <parameter key="value_type" value="numeric"/>
    <parameter key="aggregation_function" value="average"/>
    </operator>
    <operator activated="true" class="normalize" compatibility="7.5.003" expanded="true" height="103" name="Normalize" width="90" x="849" y="238">
    <parameter key="attribute_filter_type" value="single"/>
    <parameter key="attribute" value="Importance"/>
    <parameter key="method" value="range transformation"/>
    </operator>
    <operator activated="true" class="sort" compatibility="8.0.001" expanded="true" height="82" name="Sort (2)" width="90" x="581" y="120">
    <parameter key="attribute_name" value="Importance"/>
    <parameter key="sorting_direction" value="decreasing"/>
    </operator>
    <operator activated="true" class="order_attributes" compatibility="8.0.001" expanded="true" height="82" name="Reorder Attributes (3)" width="90" x="715" y="187">
    <parameter key="attribute_ordering" value="Attribute|Importance"/>
    <parameter key="handle_unmatched" value="remove"/>
    </operator>
    <connect from_port="in 1" to_op="Weight by Correlation" to_port="example set"/>
    <connect from_op="Weight by Correlation" from_port="weights" to_op="Weights to Data" to_port="attribute weights"/>
    <connect from_op="Weight by Correlation" from_port="example set" to_op="Discretize" to_port="example set input"/>
    <connect from_op="Discretize" from_port="example set output" to_op="Weight by Gini Index" to_port="example set"/>
    <connect from_op="Weights to Data" from_port="example set" to_op="Generate Attributes (2)" to_port="example set input"/>
    <connect from_op="Generate Attributes (2)" from_port="example set output" to_op="Append" to_port="example set 1"/>
    <connect from_op="Weight by Gini Index" from_port="weights" to_op="Weights to Data (2)" to_port="attribute weights"/>
    <connect from_op="Weight by Gini Index" from_port="example set" to_op="Weight by Information Gain" to_port="example set"/>
    <connect from_op="Weight by Information Gain" from_port="weights" to_op="Weights to Data (3)" to_port="attribute weights"/>
    <connect from_op="Weight by Information Gain" from_port="example set" to_op="Weight by Information Gain Ratio" to_port="example set"/>
    <connect from_op="Weight by Information Gain Ratio" from_port="weights" to_op="Weights to Data (4)" to_port="attribute weights"/>
    <connect from_op="Weights to Data (2)" from_port="example set" to_op="Generate Attributes (3)" to_port="example set input"/>
    <connect from_op="Generate Attributes (3)" from_port="example set output" to_op="Append" to_port="example set 2"/>
    <connect from_op="Weights to Data (3)" from_port="example set" to_op="Generate Attributes (4)" to_port="example set input"/>
    <connect from_op="Generate Attributes (4)" from_port="example set output" to_op="Append" to_port="example set 3"/>
    <connect from_op="Weights to Data (4)" from_port="example set" to_op="Generate Attributes (5)" to_port="example set input"/>
    <connect from_op="Generate Attributes (5)" from_port="example set output" to_op="Append" to_port="example set 4"/>
    <connect from_op="Append" from_port="merged set" to_op="Pivot" to_port="example set input"/>
    <connect from_op="Pivot" from_port="example set output" to_op="Generate Aggregation" to_port="example set input"/>
    <connect from_op="Generate Aggregation" from_port="example set output" to_op="Normalize" to_port="example set input"/>
    <connect from_op="Normalize" from_port="example set output" to_op="Sort (2)" to_port="example set input"/>
    <connect from_op="Sort (2)" from_port="example set output" to_op="Reorder Attributes (3)" to_port="example set input"/>
    <connect from_op="Reorder Attributes (3)" from_port="example set output" to_port="out 1"/>
    <portSpacing port="source_in 1" spacing="0"/>
    <portSpacing port="source_in 2" spacing="0"/>
    <portSpacing port="sink_out 1" spacing="0"/>
    <portSpacing port="sink_out 2" spacing="0"/>
    </process>
    </operator>
    <operator activated="true" class="optimize_parameters_grid" compatibility="8.0.001" expanded="true" height="124" name="Optimize Model" width="90" x="45" y="391">
    <list key="parameters">
    <parameter key="k-NN.k" value="[1.0;5;5;linear]"/>
    </list>
    <process expanded="true">
    <operator activated="true" class="concurrency:cross_validation" compatibility="8.0.001" expanded="true" height="145" name="Validate model" width="90" x="45" y="34">
    <parameter key="sampling_type" value="linear sampling"/>
    <process expanded="true">
    <operator activated="false" class="set_role" compatibility="8.0.001" expanded="true" height="82" name="Set Role" width="90" x="45" y="34">
    <parameter key="attribute_name" value="V1"/>
    <list key="set_additional_roles">
    <parameter key="V1" value="label"/>
    <parameter key="V10" value="label"/>
    <parameter key="V11" value="label"/>
    <parameter key="V12" value="label"/>
    <parameter key="V13" value="label"/>
    <parameter key="V14" value="label"/>
    <parameter key="V15" value="label"/>
    <parameter key="V16" value="label"/>
    <parameter key="V2" value="label"/>
    <parameter key="V3" value="label"/>
    <parameter key="V4" value="label"/>
    <parameter key="V5" value="label"/>
    <parameter key="V6" value="label"/>
    <parameter key="V7" value="label"/>
    <parameter key="V8" value="label"/>
    <parameter key="V9" value="label"/>
    </list>
    </operator>
    <operator activated="true" class="k_nn" compatibility="8.0.001" expanded="true" height="82" name="k-NN" width="90" x="179" y="34">
    <parameter key="k" value="5"/>
    <parameter key="measure_types" value="NumericalMeasures"/>
    <parameter key="numerical_measure" value="KernelEuclideanDistance"/>
    <parameter key="kernel_type" value="epanechnikov"/>
    </operator>
    <connect from_port="training set" to_op="k-NN" to_port="training set"/>
    <connect from_op="k-NN" from_port="model" to_port="model"/>
    <portSpacing port="source_training set" spacing="0"/>
    <portSpacing port="sink_model" spacing="0"/>
    <portSpacing port="sink_through 1" spacing="0"/>
    </process>
    <process expanded="true">
    <operator activated="true" class="apply_model" compatibility="8.0.001" expanded="true" height="82" name="Apply model" width="90" x="45" y="34">
    <list key="application_parameters"/>
    </operator>
    <operator activated="true" class="performance" compatibility="8.0.001" expanded="true" height="82" name="Performance" width="90" x="179" y="34"/>
    <operator activated="true" class="log" compatibility="8.0.001" expanded="true" height="82" name="Log model performance" width="90" x="380" y="34">
    <parameter key="filename" value="C:\Users\personal\Documents\logmodelperformance.log"/>
    <list key="log">
    <parameter key="k" value="operator.k-NN.parameter.k"/>
    <parameter key="Accuracy" value="operator.Validate model.value.performance main criterion"/>
    <parameter key="Standard Deviation" value="operator.Validate model.value.std deviation main criterion"/>
    </list>
    </operator>
    <connect from_port="model" to_op="Apply model" to_port="model"/>
    <connect from_port="test set" to_op="Apply model" to_port="unlabelled data"/>
    <connect from_op="Apply model" from_port="labelled data" to_op="Performance" to_port="labelled data"/>
    <connect from_op="Performance" from_port="performance" to_op="Log model performance" to_port="through 1"/>
    <connect from_op="Log model performance" from_port="through 1" to_port="performance 1"/>
    <portSpacing port="source_model" spacing="0"/>
    <portSpacing port="source_test set" spacing="0"/>
    <portSpacing port="source_through 1" spacing="0"/>
    <portSpacing port="sink_test set results" spacing="0"/>
    <portSpacing port="sink_performance 1" spacing="0"/>
    <portSpacing port="sink_performance 2" spacing="0"/>
    </process>
    </operator>
    <connect from_port="input 1" to_op="Validate model" to_port="example set"/>
    <connect from_op="Validate model" from_port="model" to_port="result 1"/>
    <connect from_op="Validate model" from_port="performance 1" to_port="performance"/>
    <portSpacing port="source_input 1" spacing="0"/>
    <portSpacing port="source_input 2" spacing="0"/>
    <portSpacing port="sink_performance" spacing="0"/>
    <portSpacing port="sink_result 1" spacing="0"/>
    <portSpacing port="sink_result 2" spacing="0"/>
    </process>
    </operator>
    <operator activated="false" class="apply_model" compatibility="8.0.001" expanded="true" height="82" name="Score New Data" width="90" x="581" y="391">
    <list key="application_parameters"/>
    </operator>
    <operator activated="false" class="subprocess" compatibility="8.0.001" expanded="true" height="82" name="Postprocess Scores" width="90" x="715" y="340">
    <process expanded="true">
    <operator activated="true" class="sort" compatibility="8.0.001" expanded="true" height="82" name="Sort" width="90" x="45" y="34">
    <parameter key="attribute_name" value="confidence(yes)"/>
    <parameter key="sorting_direction" value="decreasing"/>
    </operator>
    <operator activated="true" class="select_attributes" compatibility="8.0.001" expanded="true" height="82" name="Remove columns" width="90" x="179" y="34">
    <parameter key="invert_selection" value="true"/>
    </operator>
    <connect from_port="in 1" to_op="Sort" to_port="example set input"/>
    <connect from_op="Sort" from_port="example set output" to_op="Remove columns" to_port="example set input"/>
    <connect from_op="Remove columns" from_port="example set output" to_port="out 1"/>
    <portSpacing port="source_in 1" spacing="0"/>
    <portSpacing port="source_in 2" spacing="0"/>
    <portSpacing port="sink_out 1" spacing="0"/>
    <portSpacing port="sink_out 2" spacing="0"/>
    </process>
    </operator>
    <operator activated="true" class="log" compatibility="8.0.001" expanded="true" height="82" name="Log" width="90" x="179" y="391">
    <parameter key="filename" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\Predictive maintenance\falla.log"/>
    <list key="log">
    <parameter key="V1" value="operator.Log.value."/>
    <parameter key="V2" value="operator.Log.value."/>
    <parameter key="V3" value="operator.Log.value."/>
    <parameter key="V4" value="operator.Log.value."/>
    <parameter key="V5" value="operator.Log.value."/>
    <parameter key="V6" value="operator.Log.value."/>
    <parameter key="V7" value="operator.Log.value."/>
    <parameter key="V8" value="operator.Log.value."/>
    <parameter key="V9" value="operator.Log.value.applycount"/>
    <parameter key="V10" value="operator.Log.value."/>
    <parameter key="V11" value="operator.Log.value."/>
    <parameter key="V12" value="operator.Log.value."/>
    <parameter key="V13" value="operator.Log.value."/>
    <parameter key="V14" value="operator.Log.value."/>
    <parameter key="V15" value="operator.Log.value."/>
    <parameter key="V16" value="operator.Log.value."/>
    </list>
    </operator>
    <operator activated="true" class="log_to_data" compatibility="8.0.001" expanded="true" height="103" name="Create Log Data" width="90" x="380" y="340">
    <parameter key="log_name" value="Log model performance"/>
    </operator>
    <connect from_op="Load New Data" from_port="output" to_op="Select Attributes (2)" to_port="example set input"/>
    <connect from_op="Select Attributes (2)" from_port="example set output" to_op="Score New Data" to_port="unlabelled data"/>
    <connect from_op="Read CSV" from_port="output" to_op="Set Role (2)" to_port="example set input"/>
    <connect from_op="Set Role (2)" from_port="example set output" to_op="Select Attributes" to_port="example set input"/>
    <connect from_op="Select Attributes" from_port="example set output" to_op="Multiply data" to_port="input"/>
    <connect from_op="Select Attributes" from_port="original" to_op="Optimize Model" to_port="input 1"/>
    <connect from_op="Multiply data" from_port="output 1" to_op="Determine Influence Factors" to_port="in 1"/>
    <connect from_op="Determine Influence Factors" from_port="out 1" to_port="result 1"/>
    <connect from_op="Optimize Model" from_port="performance" to_op="Log" to_port="through 1"/>
    <connect from_op="Score New Data" from_port="labelled data" to_op="Postprocess Scores" to_port="in 1"/>
    <connect from_op="Log" from_port="through 1" to_op="Create Log Data" to_port="through 1"/>
    <connect from_op="Create Log Data" from_port="exampleSet" to_port="result 2"/>
    <portSpacing port="source_input 1" spacing="0"/>
    <portSpacing port="sink_result 1" spacing="0"/>
    <portSpacing port="sink_result 2" spacing="0"/>
    <portSpacing port="sink_result 3" spacing="0"/>
    <portSpacing port="sink_result 4" spacing="0"/>
    <description align="left" color="green" colored="true" height="300" resized="true" width="320" x="20" y="330">&lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; Step 3:&lt;br&gt;Train a k-NN model - optimizing for k (the number of reference situations to take into account for prediction) to produce a maximum failure prediction accuracy.</description>
    <description align="left" color="yellow" colored="false" height="70" resized="true" width="850" x="20" y="25">PREDICTIVE MAINTENANCE&lt;br&gt;Model equipment failures based on data referencing observations of past machine runs and failures. Apply model to current situations to anticipate machine failures and schedule maintenance pre-emptively.</description>
    <description align="left" color="purple" colored="true" height="215" resized="true" width="520" x="350" y="105">Step 2:&lt;br/&gt;Determine influence factors using various attribute weighting algorithms and averaging their weights results.</description>
    <description align="left" color="green" colored="true" height="300" resized="true" width="520" x="350" y="330">&lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; Step 4:&lt;br/&gt;Load new data and apply the machine failure model to current machine runs to predict potential machine failures.&lt;br&gt;</description>
    <description align="left" color="yellow" colored="false" height="35" resized="false" width="850" x="20" y="640">Outputs: influence factors, k-NN optimization log, failure predictions</description>
    </process>
    </operator>
    </process>

     

    I hope it helps,

     

    Regards, 

     

    Lionel

     

    sgenzer
Sign In or Register to comment.