🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

How can i extract automaticaly ColumnName from Matrix

User: "wawan_beta"
New Altair Community Member
Updated by Jocelyn
Hello, please sorry for my english)

i use  operator  "Loop Attributes"  and in this operators i use operator "Set Macro" and Generate Attributes. I have Matrix that have 0 and 1. I try to change Value in the fields which has 1 and  put there the Column Name. 

in Set Macro i wrote in Macro field "atts" and value field "%{loop_attribute}"
and in Generate Attributes i wrote in attribute name "%{atts}" and in the function expression field "if(%{atts}==1,str(%{atts}),"")"

but it still generate Matrix only with 1, without columnNames.

Please help me)


<?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="867" width="1150">
      <operator activated="false" class="read_excel" compatibility="5.2.008" expanded="true" height="60" name="Read Excel" width="90" x="45" y="30">
        <parameter key="excel_file" value="Y:\Eigene Dateien\RapidMiner\Beispieldaten2.xlsx"/>
        <parameter key="sheet_number" value="2"/>
        <parameter key="imported_cell_range" value="A1:AB142"/>
        <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="Kundenaussage.true.polynominal.attribute"/>
          <parameter key="1" value="Werkstattaussage.true.polynominal.attribute"/>
          <parameter key="2" value="BeanstandungsID.true.integer.attribute"/>
          <parameter key="3" value="Bauteil Werkstatt.true.polynominal.attribute"/>
          <parameter key="4" value="Fehlerart Werkstatt.true.polynominal.attribute"/>
          <parameter key="5" value="Bauteil  Fehlerart Kunde.true.polynominal.attribute"/>
          <parameter key="6" value="Bauteil Kunde.true.polynominal.attribute"/>
          <parameter key="7" value="Fehlerart Kunde.true.polynominal.attribute"/>
          <parameter key="8" value="KA1.true.polynominal.attribute"/>
          <parameter key="9" value="KA2.true.polynominal.attribute"/>
          <parameter key="10" value="KA3.true.polynominal.attribute"/>
          <parameter key="11" value="KA4.true.polynominal.attribute"/>
          <parameter key="12" value="KA5.true.polynominal.attribute"/>
          <parameter key="13" value="KA6.true.polynominal.attribute"/>
          <parameter key="14" value="KA7.true.polynominal.attribute"/>
          <parameter key="15" value="KA8.true.polynominal.attribute"/>
          <parameter key="16" value="KA9.true.polynominal.attribute"/>
          <parameter key="17" value="KA10.true.polynominal.attribute"/>
          <parameter key="18" value="KA11.true.polynominal.attribute"/>
          <parameter key="19" value="KA12.true.polynominal.attribute"/>
          <parameter key="20" value="KA13.false.binominal.attribute"/>
          <parameter key="21" value="KA14.false.binominal.attribute"/>
          <parameter key="22" value="KA15.false.binominal.attribute"/>
          <parameter key="23" value="KA16.false.binominal.attribute"/>
          <parameter key="24" value="KA17.false.binominal.attribute"/>
          <parameter key="25" value="KA18.false.attribute_value.attribute"/>
          <parameter key="26" value="KA19.false.attribute_value.attribute"/>
        </list>
      </operator>
      <operator activated="false" class="select_attributes" compatibility="5.2.008" expanded="true" height="76" name="Select Attributes" width="90" x="179" y="30">
        <parameter key="attribute_filter_type" value="subset"/>
        <parameter key="attributes" value="Bauteil  Fehlerart Kunde|KA1|KA10|KA11|KA12|KA2|KA3|KA4|KA5|KA6|KA7|KA8|KA9"/>
      </operator>
      <operator activated="false" class="replace_missing_values" compatibility="5.2.008" expanded="true" height="94" name="Replace Missing Values" width="90" x="313" y="30">
        <parameter key="attribute_filter_type" value="subset"/>
        <parameter key="attributes" value="|KA9|KA8|KA7|KA6|KA5|KA17|KA16|KA15|KA14|KA13|KA12|KA11|KA10"/>
        <parameter key="include_special_attributes" value="true"/>
        <parameter key="default" value="none"/>
        <list key="columns"/>
        <parameter key="replenishment_value" value="test"/>
      </operator>
      <operator activated="false" class="text_to_nominal" compatibility="5.2.008" expanded="true" height="76" name="Text to Nominal" width="90" x="447" y="30"/>
      <operator activated="false" class="nominal_to_binominal" compatibility="5.2.008" expanded="true" height="94" name="Nominal to Binominal" width="90" x="581" y="30"/>
      <operator activated="false" class="information_extraction:line_tokenizer" compatibility="1.0.000" expanded="true" height="76" name="LineTokenizer" width="90" x="715" y="30"/>
      <operator activated="false" class="replace_missing_values" compatibility="5.2.008" expanded="true" height="94" name="Replace Missing Values (2)" width="90" x="648" y="210">
        <parameter key="default" value="none"/>
        <list key="columns"/>
        <parameter key="replenishment_value" value="none"/>
      </operator>
      <operator activated="false" class="pivot" compatibility="5.2.008" expanded="true" height="76" name="Pivot" width="90" x="782" y="210">
        <parameter key="group_attribute" value="Kundenaussage"/>
        <parameter key="index_attribute" value="Kundenaussage"/>
        <parameter key="consider_weights" value="false"/>
        <parameter key="weight_aggregation" value="count"/>
        <parameter key="skip_constant_attributes" value="false"/>
        <parameter key="datamanagement" value="boolean_sparse_array"/>
      </operator>
      <operator activated="false" class="text_to_nominal" compatibility="5.2.008" expanded="true" height="76" name="Text to Nominal (3)" width="90" x="916" y="210"/>
      <operator activated="false" class="nominal_to_binominal" compatibility="5.2.008" expanded="true" height="94" name="Nominal to Binominal (2)" width="90" x="1050" y="210"/>
      <operator activated="false" class="map" compatibility="5.2.008" expanded="true" height="76" name="Map" width="90" x="1050" y="345">
        <list key="value_mappings"/>
      </operator>
      <operator activated="true" class="retrieve" compatibility="5.2.008" expanded="true" height="60" name="Retrieve" width="90" x="45" y="210">
        <parameter key="repository_entry" value="//NewLocalRepository/BspDatei"/>
      </operator>
      <operator activated="true" class="select_attributes" compatibility="5.2.008" expanded="true" height="76" name="Select Attributes (2)" width="90" x="179" y="210">
        <parameter key="attribute_filter_type" value="single"/>
        <parameter key="attribute" value="A"/>
        <parameter key="attributes" value="A|F"/>
      </operator>
      <operator activated="true" class="filter_example_range" compatibility="5.2.008" expanded="true" height="76" name="Filter Example Range" width="90" x="313" y="210">
        <parameter key="first_example" value="2"/>
        <parameter key="last_example" value="142"/>
      </operator>
      <operator activated="true" class="subprocess" compatibility="5.2.008" expanded="true" height="94" name="Subprocess" width="90" x="447" y="210">
        <process expanded="true" height="685" width="955">
          <operator activated="true" class="text:process_document_from_data" compatibility="5.2.004" expanded="true" height="76" name="Process Documents from Data" width="90" x="246" y="30">
            <parameter key="vector_creation" value="Term Frequency"/>
            <parameter key="add_meta_information" value="false"/>
            <parameter key="datamanagement" value="boolean_sparse_array"/>
            <list key="specify_weights"/>
            <process expanded="true" height="671" width="964">
              <operator activated="true" class="text:transform_cases" compatibility="5.2.004" expanded="true" height="60" name="Transform Cases" width="90" x="45" y="30"/>
              <operator activated="true" class="text:filter_stopwords_german" compatibility="5.2.004" expanded="true" height="60" name="Filter Stopwords (German)" width="90" x="179" y="30">
                <parameter key="stop_word_list" value="Sentiment"/>
              </operator>
              <operator activated="true" class="text:tokenize" compatibility="5.2.004" expanded="true" height="60" name="Tokenize" width="90" x="313" y="30">
                <parameter key="language" value="German"/>
              </operator>
              <operator activated="true" class="text:stem_german" compatibility="5.2.004" expanded="true" height="60" name="Stem (German)" width="90" x="447" y="30"/>
              <operator activated="false" class="text:filter_tokens_by_pos" compatibility="5.2.004" expanded="true" height="60" name="Filter Tokens (by POS Tags)" width="90" x="581" y="30">
                <parameter key="language" value="German"/>
              </operator>
              <operator activated="false" class="multiply" compatibility="5.2.008" expanded="true" height="60" name="Multiply" width="90" x="715" y="30"/>
              <operator activated="true" class="text:extract_token_number" compatibility="5.2.004" expanded="true" height="60" name="Extract Token Number" width="90" x="849" y="30"/>
              <connect from_port="document" to_op="Transform Cases" to_port="document"/>
              <connect from_op="Transform Cases" from_port="document" to_op="Filter Stopwords (German)" to_port="document"/>
              <connect from_op="Filter Stopwords (German)" from_port="document" to_op="Tokenize" to_port="document"/>
              <connect from_op="Tokenize" from_port="document" to_op="Stem (German)" to_port="document"/>
              <connect from_op="Stem (German)" from_port="document" to_op="Extract Token Number" to_port="document"/>
              <connect from_op="Extract Token Number" from_port="document" to_port="document 1"/>
              <portSpacing port="source_document" spacing="0"/>
              <portSpacing port="sink_document 1" spacing="0"/>
              <portSpacing port="sink_document 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="multiply" compatibility="5.2.008" expanded="true" height="94" name="Multiply (2)" width="90" x="380" y="30"/>
          <operator activated="true" class="loop_attributes" compatibility="5.2.008" expanded="true" height="60" name="Loop Attributes" width="90" x="581" y="30">
            <process expanded="true" height="671" width="964">
              <operator activated="false" class="multiply" compatibility="5.2.008" expanded="true" height="60" name="Multiply (3)" width="90" x="246" y="480"/>
              <operator activated="false" class="extract_macro" compatibility="5.2.008" expanded="true" height="60" name="Extract Macro" width="90" x="246" y="255">
                <parameter key="macro" value="atts"/>
              </operator>
              <operator activated="true" class="set_macro" compatibility="5.2.008" expanded="true" height="76" name="Set Macro" width="90" x="313" y="30">
                <parameter key="macro" value="atts"/>
                <parameter key="value" value="%{loop_attribute}"/>
              </operator>
              <operator activated="true" class="generate_attributes" compatibility="5.2.008" expanded="true" height="76" name="Generate Attributes" width="90" x="514" y="30">
                <list key="function_descriptions">
                  <parameter key="%{atts}" value="if(%{atts}==1,str(%{atts}),&quot;&quot;)"/>
                </list>
              </operator>
              <operator activated="false" class="set_data" compatibility="5.2.008" expanded="true" height="76" name="Set Data" width="90" x="648" y="255">
                <parameter key="example_index" value="1"/>
                <parameter key="attribute_name" value="%{atts}"/>
                <parameter key="value" value="333"/>
                <list key="additional_values"/>
              </operator>
              <connect from_port="example set" to_op="Set Macro" to_port="through 1"/>
              <connect from_op="Set Macro" from_port="through 1" to_op="Generate Attributes" to_port="example set input"/>
              <connect from_op="Generate Attributes" from_port="example set output" to_port="example set"/>
              <portSpacing port="source_example set" spacing="0"/>
              <portSpacing port="sink_example set" spacing="0"/>
            </process>
          </operator>
          <operator activated="false" class="text:wordlist_to_data" compatibility="5.2.004" expanded="true" height="76" name="WordList to Data" width="90" x="45" y="435"/>
          <operator activated="false" class="loop_values" compatibility="5.2.008" expanded="true" height="60" name="Loop Values" width="90" x="45" y="525">
            <parameter key="attribute" value="A"/>
            <parameter key="iteration_macro" value="142"/>
            <process expanded="true" height="671" width="950">
              <portSpacing port="source_example set" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
            </process>
          </operator>
          <operator activated="false" class="select_attributes" compatibility="5.2.008" expanded="true" height="76" name="AttributeFilter (2)" width="90" x="514" y="435">
            <parameter key="attribute_filter_type" value="regular_expression"/>
            <parameter key="regular_expression" value=".*true.*"/>
          </operator>
          <operator activated="false" breakpoints="after" class="fp_growth" compatibility="5.2.008" expanded="true" height="76" name="FP-Growth (2)" width="90" x="648" y="435">
            <parameter key="min_number_of_itemsets" value="20"/>
            <parameter key="max_number_of_retries" value="25"/>
            <parameter key="min_support" value="0.15"/>
            <parameter key="max_items" value="5"/>
            <parameter key="must_contain" value="fach"/>
          </operator>
          <operator activated="false" class="create_association_rules" compatibility="5.2.008" expanded="true" height="76" name="AssociationRuleGenerator (3)" width="90" x="782" y="435"/>
          <operator activated="false" class="rename" compatibility="5.2.008" expanded="true" height="76" name="Rename" width="90" x="45" y="210">
            <list key="rename_additional_attributes"/>
          </operator>
          <operator activated="false" class="generate_attributes" compatibility="5.2.008" expanded="true" height="76" name="Generate Attributes (2)" width="90" x="380" y="435">
            <list key="function_descriptions">
              <parameter key="columnName" value="columnName"/>
            </list>
          </operator>
          <connect from_port="in 1" to_op="Process Documents from Data" to_port="example set"/>
          <connect from_op="Process Documents from Data" from_port="example set" to_op="Multiply (2)" to_port="input"/>
          <connect from_op="Multiply (2)" from_port="output 1" to_op="Loop Attributes" to_port="example set"/>
          <connect from_op="Multiply (2)" from_port="output 2" to_port="out 2"/>
          <connect from_op="Loop Attributes" from_port="example set" to_port="out 1"/>
          <connect from_op="FP-Growth (2)" from_port="frequent sets" to_op="AssociationRuleGenerator (3)" to_port="item sets"/>
          <portSpacing port="source_in 1" spacing="0"/>
          <portSpacing port="source_in 2" spacing="0"/>
          <portSpacing port="sink_out 1" spacing="0"/>
          <portSpacing port="sink_out 2" spacing="0"/>
          <portSpacing port="sink_out 3" spacing="0"/>
        </process>
      </operator>
      <connect from_op="Read Excel" from_port="output" to_op="Select Attributes" to_port="example set input"/>
      <connect from_op="Select Attributes" from_port="example set output" to_op="Replace Missing Values" to_port="example set input"/>
      <connect from_op="Replace Missing Values" from_port="original" to_op="Text to Nominal" to_port="example set input"/>
      <connect from_op="Text to Nominal" from_port="example set output" to_op="Nominal to Binominal" to_port="example set input"/>
      <connect from_op="Nominal to Binominal" from_port="example set output" to_op="LineTokenizer" to_port="example set input"/>
      <connect from_op="Replace Missing Values (2)" from_port="example set output" to_op="Pivot" to_port="example set input"/>
      <connect from_op="Pivot" from_port="example set output" to_op="Text to Nominal (3)" to_port="example set input"/>
      <connect from_op="Text to Nominal (3)" from_port="example set output" to_op="Nominal to Binominal (2)" to_port="example set input"/>
      <connect from_op="Retrieve" from_port="output" to_op="Select Attributes (2)" to_port="example set input"/>
      <connect from_op="Select Attributes (2)" from_port="example set output" to_op="Filter Example Range" to_port="example set input"/>
      <connect from_op="Filter Example Range" from_port="example set output" to_op="Subprocess" to_port="in 1"/>
      <connect from_op="Subprocess" from_port="out 1" to_port="result 1"/>
      <connect from_op="Subprocess" from_port="out 2" 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>

Find more posts tagged with