Remove missing numerical values

MuehliMan

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

haddock

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>

MuehliMan

Thank you haddock for the fast help!

That was exactly the thing I needed.

Best regards,
Markus