[solved] Fill missing value

greg

my problem is : on some rows, the value of attr1 is missing ; on these rows only, I'd like to fill this value with a formula, such as "if (attr2 > 10) then (attr2 - 10) else (attr3 / 2)".

can I do that without adding a new attribute to all rows and use the  "multiple" operator?

TIA

greg

MariusHelf

Hi, that's not possible. You can use something like the process below. Note that the Rename by Replace operator in the beginning replaces all minus "-" in the attribute names to "_" to not confuse the expression parser in Generate Attributes.

Best, Marius

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.1.015">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="5.1.015" expanded="true" name="Process">
    <process expanded="true" height="280" width="681">
      <operator activated="true" class="retrieve" compatibility="5.1.015" expanded="true" height="60" name="Retrieve" width="90" x="45" y="30">
        <parameter key="repository_entry" value="//Samples/data/Labor-Negotiations"/>
      </operator>
      <operator activated="true" class="rename_by_replacing" compatibility="5.1.015" expanded="true" height="76" name="Rename by Replacing" width="90" x="179" y="30">
        <parameter key="include_special_attributes" value="true"/>
        <parameter key="replace_what" value="-"/>
        <parameter key="replace_by" value="_"/>
      </operator>
      <operator activated="true" class="generate_attributes" compatibility="5.1.015" expanded="true" height="76" name="Generate Attributes" width="90" x="313" y="30">
        <list key="function_descriptions">
          <parameter key="wage_inc_3rd_replacement" value="if(missing(wage_inc_3rd),if(duration&gt;2,duration-10,duration/3),wage_inc_3rd)"/>
        </list>
      </operator>
      <operator activated="true" class="select_attributes" compatibility="5.1.015" expanded="true" height="76" name="Select Attributes" width="90" x="447" y="30">
        <parameter key="attribute_filter_type" value="single"/>
        <parameter key="attribute" value="wage_inc_3rd"/>
        <parameter key="invert_selection" value="true"/>
      </operator>
      <operator activated="true" class="rename" compatibility="5.1.015" expanded="true" height="76" name="Rename" width="90" x="581" y="30">
        <parameter key="old_name" value="wage_inc_3rd_replacement"/>
        <parameter key="new_name" value="wage_inc_3rd"/>
        <list key="rename_additional_attributes"/>
      </operator>
      <connect from_op="Retrieve" from_port="output" to_op="Rename by Replacing" to_port="example set input"/>
      <connect from_op="Rename by Replacing" from_port="example set output" to_op="Generate Attributes" to_port="example set input"/>
      <connect from_op="Generate Attributes" from_port="example set output" to_op="Select Attributes" to_port="example set input"/>
      <connect from_op="Select Attributes" from_port="example set output" to_op="Rename" to_port="example set input"/>
      <connect from_op="Rename" 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>