🎉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

Rename operator

User: "Legacy User"
Legacy User
New Altair Community Member
Updated by Jocelyn
Hello,

I have a Read CSV operator, and the data source is: http://archive.ics.uci.edu/ml/machine-learning-databases/blood-transfusion/transfusion.data
Ok, now i wanna use a Rename operator, to rename those attributes.. if you run the process you'll see that the 1st attribute, for example is Recency (months), then Frequency (times) and so on..
But i cannot use the rename attribute.. i cannot specify the old name, and to provide a new name. WHY? I need to rename because i wanna use a Write database operator, and the attribute names are the columns of the database table.

Some ideas?
Thanks

Find more posts tagged with

AI Studio
Sort by:
1 - 1 of 11
    User: "Andrew2"
    Andrew2
    New Altair Community Member
    Hello

    It often looks like it won't work because the metadata has got lost but if you simply enter the name of the attributes manually, you can get what you want.

    Here's an example 
    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <process version="5.1.006">
      <context>
        <input/>
        <output/>
        <macros/>
      </context>
      <operator activated="true" class="process" compatibility="5.1.006" expanded="true" name="Process">
        <process expanded="true" height="618" width="1119">
          <operator activated="true" class="read_csv" compatibility="5.1.006" expanded="true" height="60" name="Read CSV" width="90" x="45" y="30">
            <parameter key="csv_file" value="http://archive.ics.uci.edu/ml/machine-learning-databases/blood-transfusion/transfusion.data"/>
            <parameter key="column_separators" value=","/>
            <list key="annotations"/>
            <list key="data_set_meta_data_information"/>
          </operator>
          <operator activated="true" class="rename" compatibility="5.1.006" expanded="true" height="76" name="Rename" width="90" x="179" y="30">
            <parameter key="old_name" value="Recency (months)"/>
            <parameter key="new_name" value="recency"/>
            <list key="rename_additional_attributes">
              <parameter key="Frequency (times)" value="frequency"/>
              <parameter key="Monetary (c.c. blood)" value="monetary"/>
              <parameter key="Time (months)" value="time"/>
              <parameter key="whether he/she donated blood in March 2007" value="whether"/>
            </list>
          </operator>
          <connect from_op="Read CSV" from_port="output" to_op="Rename" to_port="example set input"/>
          <connect from_op="Rename" 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>
    regards

    Andrew
Quick Links