Attribute construction.

ratheesan

Hi,
I have a problem while I am using if conditions in Attribute Construction Operator.Always getting an error message like " 'Syntax Error (implicit multiplication not enabled)".I am attaching my process here.

<operator name="Root" class="Process" expanded="yes">
    <operator name="ExcelExampleSource" class="ExcelExampleSource">
        <parameter key="excel_file" value="C:\Documents and Settings\ADMIN\Desktop\combined.xls"/>
        <parameter key="first_row_as_names" value="true"/>
    </operator>
    <operator name="Aggregation" class="Aggregation">
        <list key="aggregation_attributes">
          <parameter key="Cycle Time" value="average"/>
          <parameter key="File Quality Manager" value="average"/>
          <parameter key="File Quality CR" value="average"/>
          <parameter key="File Quality Supervisor" value="average"/>
          <parameter key="Customer Experience" value="average"/>
          <parameter key="Estimate Accuracy" value="average"/>
        </list>
        <parameter key="group_by_attributes" value="OFFICE"/>
        <parameter key="only_distinct" value="true"/>
    </operator>
    <operator name="AttributeConstruction" class="AttributeConstruction">
        <list key="function_descriptions">
          <parameter key="FileQualityManager" value="if(average(File Quality Manager))&lt;80,&quot;Low&quot;,if(average(File Quality Manager))&lt;90,&quot;Medium&quot;,if(average(File Quality Manager))&lt;=100,&quot;High&quot;,&quot;Other&quot;)))"/>
          <parameter key="FileQualitySupervisor" value="if(average(File Quality Supervisor))&lt;76,&quot;Low&quot;,if(average(File Quality Supervisor) )&lt;88,&quot;Medium&quot;,if(average(File Quality Supervisor))&lt;=100,&quot;High&quot;,&quot;Other&quot;)))"/>
          <parameter key="FileQualityCR" value="if(average(File Quality CR))&lt;87,&quot;Low&quot;,if(average(File Quality CR))&lt;94,&quot;Medium&quot;,if(average(File Quality CR))&lt;=100,&quot;High&quot;,&quot;Other&quot;)))"/>
        </list>
    </operator>
    <operator name="ExcelExampleSetWriter" class="ExcelExampleSetWriter">
        <parameter key="excel_file" value="C:\Documents and Settings\ADMIN\Desktop\levels.xls"/>
    </operator>
</operator>

Thanks
Ratheesan

IngoRM

Hi,

the reason for this is that the operator "Generate Attributes"  ("Attribute Construction" in RM < 5) does not support attribute names with empty spaces. The name

File Quality Manager

is interpreted as

File * Quality * Manager

which is disabled by default. Exactly for this reason: because the attributes "File" and "Quality" would not exist. Currently, the only solution is to use underscores '_' instead of spaces in attribute names, i.e. please use "File_Quality_Manager" instead. Of course you can rename your attributes back after the construction. If you want to rename them in a convenient way, you can use the operator "Rename by Replacing" and replace all spaces by underscores automatically.

Cheers,
Ingo