no key attribute list shown for Join in tutorial process

mlubicz

I follow Tutorial on Merging and Grouping within Get Started. Under 3/6 Join the data I have: - retrieved Products and Transactions - selected Join and connected it with two data tables - under 4. selected Edit List (of attributes) but no List was shown What am I doing wrong?

IngoRM

Well, the process works for me as expected.  But from your screenshot I can see that the Retrieve operators for some reason did not fetch the meta data from the Sample repository.  Maybe there was something in background happening (like indexing your repository entries for search etc.) preventing this.  May I ask you to close RapidMiner Studio and start it again?  Please pay attention to the area in the bottom right corner (which should indicate if things happen in the background).  If nothing suspicious happens there (any longer), please try to build the process from Scratch again (i.e. drag in the data sets to the process panel etc.)

If that still does not work then, please let me know, we would need to dive deeper in this case...

Many thanks for your support on this,
Ingo

mlubicz

Thank you Varun, it solves, I didn,t know the trick.

Best regards

MLubicz

varunm1

Hello @mlubicz

Did you try the highlighted parts in the below screenshot? Also you should uncheck the use id as attribute parameter.

mlubicz

1. I have not unchecked the use id as attribute parameter, as Join operator came with unchecked box

2. I see no attributes in the edit parameter window (no items)

mlubicz

varunm1

Can you post your XML process? You can find it in View --> Show Panel --> XML Please copy and paste your process from XML window here. You can also try my process which is below in your rapidminer. To do that, you can copy the code from below and paste it in the XML window which you can access as informed earlier and click on Green tick mark. Then you can see my process.

<?xml version="1.0" encoding="UTF-8"?><process version="9.2.001">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="9.2.001" expanded="true" name="Process">
<parameter key="logverbosity" value="init"/>
<parameter key="random_seed" value="2001"/>
<parameter key="send_mail" value="never"/>
<parameter key="notification_email" value=""/>
<parameter key="process_duration_for_mail" value="30"/>
<parameter key="encoding" value="SYSTEM"/>
<process expanded="true">
<operator activated="true" class="retrieve" compatibility="9.2.001" expanded="true" height="68" name="Retrieve Products" width="90" x="179" y="34">
<parameter key="repository_entry" value="//Samples/data/Products"/>
</operator>
<operator activated="true" class="retrieve" compatibility="9.2.001" expanded="true" height="68" name="Retrieve Transactions" width="90" x="179" y="136">
<parameter key="repository_entry" value="//Samples/data/Transactions"/>
</operator>
<operator activated="true" class="concurrency:join" compatibility="9.2.001" expanded="true" height="82" name="Join" width="90" x="380" y="85">
<parameter key="remove_double_attributes" value="true"/>
<parameter key="join_type" value="inner"/>
<parameter key="use_id_attribute_as_key" value="false"/>
<list key="key_attributes">
<parameter key="Product ID" value="Product ID"/>
</list>
<parameter key="keep_both_join_attributes" value="false"/>
</operator>
<operator activated="true" class="aggregate" compatibility="9.2.001" expanded="true" height="82" name="Aggregate" width="90" x="514" y="85">
<parameter key="use_default_aggregation" value="false"/>
<parameter key="attribute_filter_type" value="all"/>
<parameter key="attribute" value=""/>
<parameter key="attributes" value=""/>
<parameter key="use_except_expression" value="false"/>
<parameter key="value_type" value="attribute_value"/>
<parameter key="use_value_type_exception" value="false"/>
<parameter key="except_value_type" value="time"/>
<parameter key="block_type" value="attribute_block"/>
<parameter key="use_block_type_exception" value="false"/>
<parameter key="except_block_type" value="value_matrix_row_start"/>
<parameter key="invert_selection" value="false"/>
<parameter key="include_special_attributes" value="false"/>
<parameter key="default_aggregation_function" value="average"/>
<list key="aggregation_attributes"/>
<parameter key="group_by_attributes" value=""/>
<parameter key="count_all_combinations" value="false"/>
<parameter key="only_distinct" value="false"/>
<parameter key="ignore_missings" value="true"/>
</operator>
<connect from_op="Retrieve Products" from_port="output" to_op="Join" to_port="left"/>
<connect from_op="Retrieve Transactions" from_port="output" to_op="Join" to_port="right"/>
<connect from_op="Join" from_port="join" to_op="Aggregate" to_port="example set input"/>
<connect from_op="Aggregate" 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>

mlubicz

Seems the same, my code below. Product ID was inputted, not selected from a list.

The real question is why one cannot see the list of attributes, neither in Join nor in Aggregate.

<?xml version="1.0" encoding="UTF-8"?><process version="9.2.001">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="9.2.001" expanded="true" name="Process">
    <parameter key="logverbosity" value="init"/>
    <parameter key="random_seed" value="2001"/>
    <parameter key="send_mail" value="never"/>
    <parameter key="notification_email" value=""/>
    <parameter key="process_duration_for_mail" value="30"/>
    <parameter key="encoding" value="SYSTEM"/>
    <process expanded="true">
      <operator activated="true" class="retrieve" compatibility="9.2.001" expanded="true" height="68" name="Retrieve Products" width="90" x="45" y="34">
        <parameter key="repository_entry" value="//Samples/data/Products"/>
      </operator>
      <operator activated="true" class="retrieve" compatibility="9.2.001" expanded="true" height="68" name="Retrieve Transactions" width="90" x="45" y="136">
        <parameter key="repository_entry" value="//Samples/data/Transactions"/>
      </operator>
      <operator activated="true" class="concurrency:join" compatibility="9.2.001" expanded="true" height="82" name="Join" width="90" x="179" y="85">
        <parameter key="remove_double_attributes" value="true"/>
        <parameter key="join_type" value="inner"/>
        <parameter key="use_id_attribute_as_key" value="false"/>
        <list key="key_attributes">
          <parameter key="Product ID" value="Product ID"/>
        </list>
        <parameter key="keep_both_join_attributes" value="false"/>
      </operator>
      <operator activated="true" class="aggregate" compatibility="9.2.001" expanded="true" height="82" name="Aggregate" width="90" x="380" y="85">
        <parameter key="use_default_aggregation" value="false"/>
        <parameter key="attribute_filter_type" value="all"/>
        <parameter key="attribute" value=""/>
        <parameter key="attributes" value=""/>
        <parameter key="use_except_expression" value="false"/>
        <parameter key="value_type" value="attribute_value"/>
        <parameter key="use_value_type_exception" value="false"/>
        <parameter key="except_value_type" value="time"/>
        <parameter key="block_type" value="attribute_block"/>
        <parameter key="use_block_type_exception" value="false"/>
        <parameter key="except_block_type" value="value_matrix_row_start"/>
        <parameter key="invert_selection" value="false"/>
        <parameter key="include_special_attributes" value="false"/>
        <parameter key="default_aggregation_function" value="average"/>
        <list key="aggregation_attributes"/>
        <parameter key="group_by_attributes" value=""/>
        <parameter key="count_all_combinations" value="false"/>
        <parameter key="only_distinct" value="false"/>
        <parameter key="ignore_missings" value="true"/>
      </operator>
      <connect from_op="Retrieve Products" from_port="output" to_op="Join" to_port="left"/>
      <connect from_op="Retrieve Transactions" from_port="output" to_op="Join" to_port="right"/>
      <connect from_op="Join" from_port="join" to_op="Aggregate" to_port="example set input"/>
      <connect from_op="Aggregate" 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>

varunm1

Actually, I am selecting from list. I think I found your issue. Can you check if your " Validate automaticall" id checked? This is available in Process bar in menu items. Please check it and try with a new process or by restarting rapidminer. If this is not checked your metadata might not sync and you can not see lists

IngoRM

Well, the process works for me as expected.  But from your screenshot I can see that the Retrieve operators for some reason did not fetch the meta data from the Sample repository.  Maybe there was something in background happening (like indexing your repository entries for search etc.) preventing this.  May I ask you to close RapidMiner Studio and start it again?  Please pay attention to the area in the bottom right corner (which should indicate if things happen in the background).  If nothing suspicious happens there (any longer), please try to build the process from Scratch again (i.e. drag in the data sets to the process panel etc.)

If that still does not work then, please let me know, we would need to dive deeper in this case...

Many thanks for your support on this,
Ingo

mlubicz

Thank you Varun, it solves, I didn,t know the trick.

Best regards

MLubicz

varunm1

Yep, simple things are hard to find sometimes