join object from different collection

nic__o

Dear all, i made a process whiwh split two documents (in fonction on his column), the results is 2 collections in which I have a number of object (this number = the number of column), now I want to join two objects, one from the first collection and the other one from the other, I really need your help to do this.

Thank's ! 

here the code :

<?xml version="1.0" encoding="UTF-8"?><process version="8.2.000">

  <context>

    <input/>

    <output/>

    <macros/>

  </context>

  <operator activated="true" class="process" compatibility="8.2.000" expanded="true" name="Process">

    <process expanded="true">

      <operator activated="true" class="retrieve" compatibility="8.2.000" expanded="true" height="68" name="Retrieve EEX Data" width="90" x="45" y="34">

        <parameter key="repository_entry" value="//Local Repository/Alarm 11 data"/>

      </operator>

      <operator activated="true" class="concurrency:loop_attributes" compatibility="8.2.000" expanded="true" height="82" name="Loop Attributes" width="90" x="313" y="34">

        <parameter key="attribute_filter_type" value="subset"/>

        <parameter key="attributes" value="RT_3037_A - (DS 2215) Probe: Temperature - Supply [°C]|RT_3124_I - (DS 2332) Sensor: Air flow [Pa]|RT_3357_I - (DS ----) Alarm Codes []"/>

        <parameter key="regular_expression" value="[a-zA-Z0-9\s]"/>

        <process expanded="true">

          <operator activated="true" class="select_attributes" compatibility="8.2.000" expanded="true" height="82" name="Select Attributes" width="90" x="179" y="34">

            <parameter key="attribute_filter_type" value="subset"/>

            <parameter key="attribute" value="F1BQ012018"/>

            <parameter key="attributes" value="A|%{loop_attribute}"/>

            <parameter key="regular_expression" value="F1BM"/>

          </operator>

          <operator activated="true" class="store" compatibility="8.2.000" expanded="true" height="68" name="Store" width="90" x="514" y="34">

            <parameter key="repository_entry" value="Alarm 11 data."/>

          </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="Store" to_port="input"/>

          <connect from_op="Store" from_port="through" to_port="output 1"/>

          <portSpacing port="source_input 1" spacing="0"/>

          <portSpacing port="source_input 2" spacing="0"/>

          <portSpacing port="sink_output 1" spacing="0"/>

          <portSpacing port="sink_output 2" spacing="0"/>

        </process>

      </operator>

      <operator activated="true" class="retrieve" compatibility="8.2.000" expanded="true" height="68" name="Retrieve" width="90" x="45" y="187">

        <parameter key="repository_entry" value="//Local Repository/format_alarme_11"/>

      </operator>

      <operator activated="true" class="transpose" compatibility="8.2.000" expanded="true" height="82" name="Transpose" width="90" x="246" y="187"/>

      <operator activated="true" class="concurrency:loop_attributes" compatibility="8.2.000" expanded="true" height="82" name="Loop Attributes (2)" width="90" x="380" y="187">

        <parameter key="attribute_filter_type" value="subset"/>

        <parameter key="attributes" value="att_3|att_2|att_1"/>

        <parameter key="attribute_name_macro" value="loop_attribute2"/>

        <process expanded="true">

          <operator activated="true" class="select_attributes" compatibility="8.2.000" expanded="true" height="82" name="Select Attributes (2)" width="90" x="112" y="34">

            <parameter key="attribute_filter_type" value="subset"/>

            <parameter key="attributes" value="id|%{loop_attribute2}"/>

          </operator>

          <connect from_port="input 1" to_op="Select Attributes (2)" to_port="example set input"/>

          <connect from_op="Select Attributes (2)" from_port="example set output" to_port="output 1"/>

          <portSpacing port="source_input 1" spacing="0"/>

          <portSpacing port="source_input 2" spacing="0"/>

          <portSpacing port="sink_output 1" spacing="0"/>

          <portSpacing port="sink_output 2" spacing="0"/>

        </process>

      </operator>

      <connect from_op="Retrieve EEX Data" from_port="output" to_op="Loop Attributes" to_port="input 1"/>

      <connect from_op="Loop Attributes" from_port="output 1" to_port="result 1"/>

      <connect from_op="Retrieve" from_port="output" to_op="Transpose" to_port="example set input"/>

      <connect from_op="Transpose" from_port="example set output" to_op="Loop Attributes (2)" to_port="input 1"/>

      <connect from_op="Loop Attributes (2)" from_port="output 1" to_port="result 2"/>

      <portSpacing port="source_input 1" spacing="0"/>

      <portSpacing port="sink_result 1" spacing="0"/>

      <portSpacing port="sink_result 2" spacing="0"/>

      <portSpacing port="sink_result 3" spacing="0"/>

    </process>

  </operator>

</process>

sgenzer

@nic__o can you please also attach your .ioo files so we can run this code?

Scott

Telcontar120

Without your data it's difficult to know, but you would need to first use the Select operator to choose a specific element in each collection to do a Join.  You can't use join on collections.