Remove missing numerical values

MuehliManMuehliMan Member Posts: 85 Maven
edited November 2018 in Help

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"/>

Thanks for your help!

Best regards,


  • 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">
     <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 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"/>
         <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"/>

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

    That was exactly the thing I needed.

    Best regards,
Sign In or Register to comment.