"[SOLVED] Join - Cannot map another string for binary attribute: already mapped s"

Hi All,

I'm trying to use the Join operator to do a look up data from the left input against a table at the right input - a "vlookup" in Excel - sorry, my IT skills are shocking.
It works for the first few key attributes but then as soon as there are multiple values in the "left key attributes" it gives this bug "Cannot map another string for binary attribute: already mapped two strings"

Any ideas how to achieve this with different operators?

Thanks in advance.

Cheers,


<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.3.008">
 <context>
   <input/>
   <output/>
   <macros/>
 </context>
 <operator activated="true" class="process" compatibility="5.3.008" expanded="true" name="Process">
   <process expanded="true">
     <operator activated="true" class="read_excel" compatibility="5.3.008" expanded="true" height="60" name="Read Excel" width="90" x="45" y="120">
       <parameter key="excel_file" value="\\Earth\rgobey\Oli\Desktop\Auspac Invoices\961.XLS"/>
       <parameter key="imported_cell_range" value="A1:J3474"/>
       <list key="annotations">
         <parameter key="0" value="Name"/>
       </list>
       <parameter key="date_format" value="dd/mm/yyyy"/>
       <list key="data_set_meta_data_information">
         <parameter key="0" value="InvoiceNo.true.binominal.attribute"/>
         <parameter key="1" value="InvoiceDate.true.date.attribute"/>
         <parameter key="2" value="OrderNo.true.polynominal.attribute"/>
         <parameter key="3" value="Client.true.binominal.attribute"/>
         <parameter key="4" value="InvoiceType.true.binominal.attribute"/>
         <parameter key="5" value="AccCode.true.binominal.attribute"/>
         <parameter key="6" value="Parameter.true.polynominal.attribute"/>
         <parameter key="7" value="Units.true.integer.attribute"/>
         <parameter key="8" value="Rate.true.numeric.attribute"/>
         <parameter key="9" value="Amount.true.numeric.attribute"/>
       </list>
     </operator>
     <operator activated="true" class="read_excel" compatibility="5.3.008" expanded="true" height="60" name="Read Excel (2)" width="90" x="45" y="210">
       <parameter key="excel_file" value="\\Earth\rgobey\Oli\Desktop\Auspac Invoices\Client Table.xlsx"/>
       <parameter key="imported_cell_range" value="A2:F26"/>
       <parameter key="first_row_as_names" value="false"/>
       <list key="annotations">
         <parameter key="0" value="Name"/>
       </list>
       <list key="data_set_meta_data_information">
         <parameter key="0" value="Client.true.binominal.attribute"/>
         <parameter key="1" value="Invoice To.true.binominal.attribute"/>
         <parameter key="2" value="InvoiceType.true.binominal.attribute"/>
         <parameter key="3" value="Invoice Type.true.binominal.attribute"/>
         <parameter key="4" value="AccCode.true.binominal.attribute"/>
         <parameter key="5" value="Charge Type.true.binominal.attribute"/>
       </list>
     </operator>
     <operator activated="true" class="join" compatibility="5.3.008" expanded="true" height="76" name="Join" width="90" x="313" y="120">
       <parameter key="use_id_attribute_as_key" value="false"/>
       <list key="key_attributes">
         <parameter key="Client" value="Client"/>
         <parameter key="InvoiceType" value="InvoiceType"/>
         <parameter key="AccCode" value="Charge Type"/>
       </list>
     </operator>
     <operator activated="true" class="generate_attributes" compatibility="5.3.008" expanded="true" height="76" name="Generate Attributes" width="90" x="447" y="120">
       <list key="function_descriptions">
         <parameter key="Charge Item" value="if(length(Parameter)&gt;1,concat(AccCode,&quot; (&quot;,Parameter,&quot;)&quot;),AccCode)"/>
       </list>
     </operator>
     <operator activated="true" class="write_excel" compatibility="5.3.008" expanded="true" height="76" name="Write Excel" width="90" x="715" y="120">
       <parameter key="excel_file" value="\\Earth\rgobey\Oli\Desktop\Auspac Invoices\Auspac Data.xlsx"/>
       <parameter key="file_format" value="xlsx"/>
       <parameter key="date_format" value="dd/mm/yyyy"/>
     </operator>
     <connect from_op="Read Excel" from_port="output" to_op="Join" to_port="left"/>
     <connect from_op="Read Excel (2)" from_port="output" to_op="Join" to_port="right"/>
     <connect from_op="Join" from_port="join" to_op="Generate Attributes" to_port="example set input"/>
     <connect from_op="Generate Attributes" from_port="example set output" to_op="Write Excel" to_port="input"/>
     <portSpacing port="source_input 1" spacing="0"/>
     <portSpacing port="sink_result 1" spacing="0"/>
   </process>
 </operator>
</process>