Remove missing numerical values

MuehliMan
MuehliMan New Altair Community Member
edited November 2024 in Community Q&A
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
Tagged:

Answers

  • haddock
    haddock New Altair Community Member
    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
    MuehliMan New Altair Community Member
    Thank you haddock for the fast help!

    That was exactly the thing I needed.

    Best regards,
    Markus

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.