🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Remove missing numerical values

User: "MuehliMan"
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with

Sort by:
1 - 2 of 21
    User: "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>

    User: "MuehliMan"
    New Altair Community Member
    OP
    Thank you haddock for the fast help!

    That was exactly the thing I needed.

    Best regards,
    Markus