"what's wrong with my Generate Attribute?"

Answers

• Options

  haddock Member Posts: 849 Maven

  April 2012

  Hi there,
  
  It might also be that your attribute names contain brackets; normally this doesn't matter, but in regex it does, you have to be very careful about escaping special characters, and avoiding others.  Here's and example which produces your error

  <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  <process version="5.2.003">
    <context>
      <input/>
      <output/>
      <macros/>
    </context>
    <operator activated="true" class="process" compatibility="5.2.003" expanded="true" name="Process">
      <process expanded="true" height="263" width="822">
        <operator activated="true" class="generate_data" compatibility="5.2.003" expanded="true" height="60" name="Generate Data" width="90" x="87" y="38"/>
        <operator activated="true" class="rename" compatibility="5.2.003" expanded="true" height="76" name="Rename" width="90" x="216" y="36">
          <parameter key="old_name" value="att1"/>
          <parameter key="new_name" value="att(1)"/>
          <list key="rename_additional_attributes"/>
        </operator>
        <operator activated="true" class="generate_attributes" compatibility="5.2.003" expanded="true" height="76" name="Generate Attributes" width="90" x="380" y="30">
          <list key="function_descriptions">
            <parameter key="Gotcha" value="att(1)+att2+att3"/>
          </list>
        </operator>
        <connect from_op="Generate Data" from_port="output" to_op="Rename" to_port="example set input"/>
        <connect from_op="Rename" 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_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>

  I know this from bitter, and recent, experience, here's some code for my RapidAnalytics server, where I read in some attributes with brackets, and scale one column against another. Don't try and run it, just check out the attribute generator, and in particular the regex...

  <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  <process version="5.2.003">
    <context>
      <input>
        <location>PricesNPatterns</location>
      </input>
      <output/>
      <macros>
        <macro>
          <key>symbol</key>
          <value/>
        </macro>
      </macros>
    </context>
    <operator activated="true" class="process" compatibility="5.2.003" expanded="true" name="Process">
      <process expanded="true" height="697" width="815">
        <operator activated="true" class="select_attributes" compatibility="5.2.003" expanded="true" height="76" name="Select Attributes" width="90" x="179" y="75">
          <parameter key="attribute_filter_type" value="regular_expression"/>
          <parameter key="regular_expression" value=".*%{symbol}"/>
        </operator>
        <operator activated="true" class="extract_macro" compatibility="5.2.003" expanded="true" height="60" name="H" width="90" x="313" y="75">
          <parameter key="macro" value="H"/>
          <parameter key="macro_type" value="statistics"/>
          <parameter key="statistics" value="max"/>
          <parameter key="attribute_name" value="AVG(C)_%{symbol}"/>
        </operator>
        <operator activated="true" class="extract_macro" compatibility="5.2.003" expanded="true" height="60" name="L" width="90" x="313" y="165">
          <parameter key="macro" value="L"/>
          <parameter key="macro_type" value="statistics"/>
          <parameter key="statistics" value="min"/>
          <parameter key="attribute_name" value="AVG(C)_%{symbol}"/>
        </operator>
        <operator activated="true" class="extract_macro" compatibility="5.2.003" expanded="true" height="60" name="MaxP" width="90" x="447" y="75">
          <parameter key="macro" value="MaxP"/>
          <parameter key="macro_type" value="statistics"/>
          <parameter key="statistics" value="max"/>
          <parameter key="attribute_name" value="Label_Sets_%{symbol}"/>
        </operator>
        <operator activated="true" class="extract_macro" compatibility="5.2.003" expanded="true" height="60" name="MinP" width="90" x="447" y="165">
          <parameter key="macro" value="MinP"/>
          <parameter key="macro_type" value="statistics"/>
          <parameter key="statistics" value="min"/>
          <parameter key="attribute_name" value="Label_Sets_%{symbol}"/>
        </operator>
        <operator activated="true" class="generate_attributes" compatibility="5.2.003" expanded="true" height="76" name="Generate Attributes" width="90" x="581" y="165">
          <list key="function_descriptions">
            <parameter key="P-%{symbol}" value="%{L}+((Label_Sets_%{symbol}-%{MinP})/(%{MaxP}-%{MinP}))*(%{H}-%{L})"/>
          </list>
        </operator>
        <operator activated="true" class="select_attributes" compatibility="5.2.003" expanded="true" height="76" name="Select Attributes (2)" width="90" x="648" y="30">
          <parameter key="attribute_filter_type" value="regular_expression"/>
          <parameter key="regular_expression" value=".*"/>
          <parameter key="use_except_expression" value="true"/>
          <parameter key="except_regular_expression" value="Label.*"/>
        </operator>
        <operator activated="true" class="rename_by_replacing" compatibility="5.2.003" expanded="true" height="76" name="Rename by Replacing" width="90" x="715" y="120">
          <parameter key="replace_what" value="AVG\(C\)\_"/>
        </operator>
        <connect from_port="input 1" to_op="Select Attributes" to_port="example set input"/>
        <connect from_op="Select Attributes" from_port="example set output" to_op="H" to_port="example set"/>
        <connect from_op="H" from_port="example set" to_op="L" to_port="example set"/>
        <connect from_op="L" from_port="example set" to_op="MaxP" to_port="example set"/>
        <connect from_op="MaxP" from_port="example set" to_op="MinP" to_port="example set"/>
        <connect from_op="MinP" from_port="example set" to_op="Generate Attributes" to_port="example set input"/>
        <connect from_op="Generate Attributes" from_port="example set output" to_op="Select Attributes (2)" to_port="example set input"/>
        <connect from_op="Select Attributes (2)" from_port="example set output" to_op="Rename by Replacing" to_port="example set input"/>
        <connect from_op="Rename by Replacing" from_port="example set output" to_port="result 1"/>
        <portSpacing port="source_input 1" spacing="0"/>
        <portSpacing port="source_input 2" spacing="0"/>
        <portSpacing port="sink_result 1" spacing="0"/>
        <portSpacing port="sink_result 2" spacing="0"/>
      </process>
    </operator>
  </process>
  

  Here the new attribute's name comes from a macro, and its value comes from another attribute, itself named using a macro, multiplied by some other macros, themselves named according to a macro. So macros and attributes in total confusion,  and the regex parser says it's illegal. What a treat, but guess what, it works...
  
  Good luck with your endeavours.
  
  
  
  

  0
• Options

  cindyharper Member Posts: 9 Contributor II

  April 2012

  So here's a real newbie question - I could see how I could make the value of an attribute available for use in the Generate Attribute operator if I made a macro, but can I call the value of an attribute directly in my Generate Attribute operator?  Can't I set the value of the new attribute to  %{InstitutionName.value} if InstitutionName is the name of one of my row attributes?

  0
• Options

  haddock Member Posts: 849 Maven

  April 2012

  Can't I set the value of the new attribute to  %{InstitutionName.value} if InstitutionName is the name of one of my row attributes?

  Yes. That happens in my second example.

  0