Remove missing numerical values

MuehliManMuehliMan Member Posts: 85 Maven
edited November 2018 in Help
Hi,

I would need something to filter out all missing numerical values (denoted as ?). I tried to use the Filter Examples Module keeping only those examples with attribute ID > 0. Unfortunately it did not remove the missing values.

        <operator activated="true" class="filter_examples" expanded="true" height="76" name="Filter Missing Numericals" width="90" x="849" y="165">
            <parameter key="condition_class" value="attribute_value_filter"/>
            <parameter key="parameter_string" value="ID&gt;0"/>
          </operator>

Thanks for your help!

Best regards,
Markus

Answers

  • haddockhaddock Member Posts: 849 Maven
    Greets Markus!

    I think 'NaN', "not a number", is what you need, like this..

    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <process version="5.0">
     <context>
       <input/>
       <output/>
       <macros/>
     </context>
     <operator activated="true" class="process" expanded="true" name="Process">
       <process expanded="true" height="-20" width="-50">
         <operator activated="true" class="retrieve" expanded="true" height="60" name="Retrieve" width="90" x="38" y="45">
           <parameter key="repository_entry" value="//Samples/data/Labor-Negotiations"/>
         </operator>
         <operator activated="true" class="filter_examples" expanded="true" height="76" name="Filter Examples" width="90" x="524" y="64">
           <parameter key="condition_class" value="attribute_value_filter"/>
           <parameter key="parameter_string" value="working-hours=NaN"/>
           <parameter key="invert_filter" value="true"/>
         </operator>
         <connect from_op="Retrieve" from_port="output" to_op="Filter Examples" to_port="example set input"/>
         <connect from_op="Filter Examples" 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>

  • MuehliManMuehliMan Member Posts: 85 Maven
    Thank you haddock for the fast help!

    That was exactly the thing I needed.

    Best regards,
    Markus
Sign In or Register to comment.