🎉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

"Applying new values based on filter"

User: "clarkem1"
New Altair Community Member
Updated by Jocelyn
Hi Chaps,

I'm sure this is qa very simple thing but I cannot seem to find an operator which will let me do it. I essentially want to apply a filter on some data then allocate it to a particular group in a column, I.E IF Column C contains this then Column D belongs in group 1.

So simple I know but I would really appreciate some help. I have watched the tutorial videos and whilst they were useful didn't really answer my questions.

Find more posts tagged with

Sort by:
1 - 2 of 21
    User: "Marco_Boeck"
    New Altair Community Member
    Hi,

    you are looking for the "Generate Attributes" operator.

    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <process version="6.6.000-SNAPSHOT">
      <context>
        <input/>
        <output/>
        <macros/>
      </context>
      <operator activated="true" class="process" compatibility="6.6.000-SNAPSHOT" expanded="true" name="Process">
        <process expanded="true">
          <operator activated="true" class="retrieve" compatibility="6.6.000-SNAPSHOT" expanded="true" height="68" name="Retrieve Deals" width="90" x="45" y="34">
            <parameter key="repository_entry" value="//Samples/data/Deals"/>
          </operator>
          <operator activated="true" class="generate_attributes" compatibility="6.6.000-SNAPSHOT" expanded="true" height="82" name="Generate Attributes" width="90" x="179" y="34">
            <list key="function_descriptions">
              <parameter key="Rating" value="if(matches([Payment Method], &quot;.*cheque.*&quot;), &quot;bad&quot;, &quot;good&quot;)"/>
            </list>
          </operator>
          <connect from_op="Retrieve Deals" from_port="output" to_op="Generate Attributes" to_port="example set input"/>
          <connect from_op="Generate Attributes" 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>
    Regards,
    Marco
    User: "clarkem1"
    New Altair Community Member
    OP
    Thanks ! :)