[SOLVED] Problems Pivoting

rosana

Good afternoon,

I have a RM process which includes a PIVOT Operator. If I include a "breakpoint" in this operator it seems that pivot is well done (as I can see the Data), but the window in the "Process View" at the output of this Operator indicates Nr of Examples = 0... Why?? What should I do?

I include the code...
Thank you!!

BestRosana

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.2.008">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="5.2.008" expanded="true" name="Process">
    <process expanded="true" height="338" width="644">
      <operator activated="true" class="retrieve" compatibility="5.2.008" expanded="true" height="60" name="Retrieve (13)" width="90" x="45" y="120">
        <parameter key="repository_entry" value="../InputData/Agoust/PPI/ArcAnl_20120822031500"/>
      </operator>
      <operator activated="true" class="rename" compatibility="5.2.008" expanded="true" height="76" name="Rename (13)" width="90" x="179" y="120">
        <parameter key="old_name" value="att2"/>
        <parameter key="new_name" value="caID"/>
        <list key="rename_additional_attributes">
          <parameter key="att6" value="SysDate"/>
          <parameter key="att13" value="ucState"/>
        </list>
      </operator>
      <operator activated="true" class="nominal_to_date" compatibility="5.2.008" expanded="true" height="76" name="Nominal to Date (13)" width="90" x="313" y="120">
        <parameter key="attribute_name" value="SysDate"/>
        <parameter key="date_type" value="date_time"/>
        <parameter key="date_format" value="dd/mm/yy hh:mm"/>
      </operator>
      <operator activated="true" class="pivot" compatibility="5.2.008" expanded="true" height="76" name="Pivot" width="90" x="447" y="120">
        <parameter key="group_attribute" value="SysDate"/>
        <parameter key="index_attribute" value="caID"/>
        <parameter key="skip_constant_attributes" value="false"/>
      </operator>
      <connect from_op="Retrieve (13)" from_port="output" to_op="Rename (13)" to_port="example set input"/>
      <connect from_op="Rename (13)" from_port="example set output" to_op="Nominal to Date (13)" to_port="example set input"/>
      <connect from_op="Nominal to Date (13)" from_port="example set output" to_op="Pivot" to_port="example set input"/>
      <connect from_op="Pivot" 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>

MariusHelf

Hi Rosana,

as far as I can see without having access to the data, the process looks fine. Did you set the breakpoint before or after the Pivot operator? Theoretically, the data cannot change between the output of the last operator and the process output.
What do you see if you rightclick the "exa" output port of Pivot and select "Show Example Set Result"?

All the best,
Marius