The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
RENAME does not show all available fields
sebastian_gonza
RapidMiner Certified Analyst, Member Posts: 52 
Guru
Best Answer
-
lionelderkrikor
RapidMiner Certified Analyst, Member Posts: 1,195 
Unicorn
Hi again @sebastian_gonza,
The problem seems solved :
it is a mistake of "inattention" (maximum(Consumo_minutos)_AAA renamed two times) :
I corrected this issue and here the new process :
<?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 anytime_partitioned_limpia" width="90" x="45" y="34">
<parameter key="repository_entry" value="//Rapidminer_Tests/data/anytime_partitioned_limpia"/>
</operator>
<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="attributes" value="bda_contract|dba_genre|dba_hr_start|dba_hr_end|fecha_hr_inicio|fecha_hr_fin|cambio_prog|dba_duration"/>
</operator>
<operator activated="true" class="generate_attributes" compatibility="8.2.000" expanded="true" height="82" name="Generate Attributes" width="90" x="313" y="34">
<list key="function_descriptions">
<parameter key="Dur_minutos" value="dba_duration/60"/>
<parameter key="hora_inicio_ok" value="cut(dba_hr_start,0,2)"/>
<parameter key="ID" value="replace(bda_contract,".","")"/>
</list>
</operator>
<operator activated="true" class="generate_attributes" compatibility="8.2.000" expanded="true" height="82" name="Generate Attributes (14)" width="90" x="447" y="34">
<list key="function_descriptions">
<parameter key="ID_ok" value="if(length(ID)==9,concat("0",ID),ID)"/>
</list>
</operator>
<operator activated="true" class="nominal_to_numerical" compatibility="8.2.000" expanded="true" height="103" name="Nominal to Numerical" width="90" x="581" y="34">
<parameter key="attribute_filter_type" value="single"/>
<parameter key="attribute" value="hora_inicio_ok"/>
<parameter key="coding_type" value="unique integers"/>
<list key="comparison_groups"/>
</operator>
<operator activated="true" class="generate_attributes" compatibility="8.2.000" expanded="true" height="82" name="Generate Attributes (2)" width="90" x="715" y="34">
<list key="function_descriptions">
<parameter key="Franjas" value="if(hora_inicio_ok>=6 && hora_inicio_ok<12,"A",if(hora_inicio_ok>=12 && hora_inicio_ok<18,"AA",if(hora_inicio_ok>=18 && hora_inicio_ok<24,"AAA","ON")))"/>
</list>
</operator>
<operator activated="true" class="nominal_to_date" compatibility="8.2.000" expanded="true" height="82" name="Nominal to Date" width="90" x="849" y="34">
<parameter key="attribute_name" value="fecha_hr_inicio"/>
<parameter key="date_format" value="yyyy-MM-dd HH:mm:ss"/>
</operator>
<operator activated="true" class="date_to_numerical" compatibility="8.2.000" expanded="true" height="82" name="Date to Numerical" width="90" x="983" y="34">
<parameter key="attribute_name" value="fecha_hr_inicio"/>
<parameter key="time_unit" value="day"/>
<parameter key="day_relative_to" value="week"/>
</operator>
<operator activated="true" class="numerical_to_polynominal" compatibility="8.2.000" expanded="true" height="82" name="Numerical to Polynominal (4)" width="90" x="1117" y="34">
<parameter key="attribute_filter_type" value="single"/>
<parameter key="attribute" value="fecha_hr_inicio"/>
</operator>
<operator activated="true" class="map" compatibility="8.2.000" expanded="true" height="82" name="Map (5)" width="90" x="1251" y="34">
<parameter key="attribute_filter_type" value="single"/>
<parameter key="attribute" value="fecha_hr_inicio"/>
<list key="value_mappings">
<parameter key="1" value="Entre semana"/>
<parameter key="2" value="Entre semana"/>
<parameter key="3" value="Entre semana"/>
<parameter key="4" value="Entre semana"/>
<parameter key="5" value="Entre semana"/>
<parameter key="6" value="Fin de semana"/>
<parameter key="7" value="Fin de semana"/>
</list>
</operator>
<operator activated="true" class="select_attributes" compatibility="8.2.000" expanded="true" height="82" name="Select Attributes (2)" width="90" x="1385" y="34">
<parameter key="attribute_filter_type" value="subset"/>
<parameter key="attributes" value="Dur_minutos|Franjas|ID|bda_contract|cambio_prog|dba_genre|fecha_hr_inicio|ID_ok"/>
</operator>
<operator activated="true" class="rename" compatibility="8.2.000" expanded="true" height="82" name="Rename" width="90" x="1117" y="187">
<parameter key="old_name" value="Dur_minutos"/>
<parameter key="new_name" value="Consumo_minutos"/>
<list key="rename_additional_attributes">
<parameter key="bda_contract" value="ID_final"/>
<parameter key="cambio_prog" value="Cambio_programa"/>
<parameter key="dba_genre" value="Genero"/>
<parameter key="fecha_hr_inicio" value="Dia semana"/>
</list>
</operator>
<operator activated="true" class="multiply" compatibility="8.2.000" expanded="true" height="124" name="Multiply" width="90" x="45" y="238"/>
<operator activated="true" class="aggregate" compatibility="8.2.000" expanded="true" height="82" name="Aggregate (3)" width="90" x="179" y="442">
<list key="aggregation_attributes">
<parameter key="Consumo_minutos" value="maximum"/>
</list>
<parameter key="group_by_attributes" value="Genero|ID_final"/>
</operator>
<operator activated="true" class="map" compatibility="8.2.000" expanded="true" height="82" name="Map" width="90" x="313" y="442">
<parameter key="attribute_filter_type" value="single"/>
<parameter key="attribute" value="Genero"/>
<list key="value_mappings">
<parameter key="Animación" value="Animacion"/>
<parameter key="Animacion" value="Animacion"/>
<parameter key="Infinity" value="Infinity"/>
<parameter key="-Infinity" value="Infinity"/>
<parameter key="Deporte" value="Deportes"/>
<parameter key="Deportes" value="Deportes"/>
<parameter key="Mundo Animal" value="Mundo Animal"/>
<parameter key="Reino Animal" value="Mundo Animal"/>
</list>
</operator>
<operator activated="true" class="pivot" compatibility="8.2.000" expanded="true" height="82" name="Genero (2)" width="90" x="447" y="442">
<parameter key="group_attribute" value="ID_final"/>
<parameter key="index_attribute" value="Genero"/>
<parameter key="skip_constant_attributes" value="false"/>
</operator>
<operator activated="true" class="aggregate" compatibility="8.2.000" expanded="true" height="82" name="Aggregate" width="90" x="179" y="238">
<list key="aggregation_attributes">
<parameter key="Consumo_minutos" value="maximum"/>
</list>
<parameter key="group_by_attributes" value="Dia semana|ID_final"/>
</operator>
<operator activated="true" class="pivot" compatibility="8.2.000" expanded="true" height="82" name="Dayweek (2)" width="90" x="313" y="238">
<parameter key="group_attribute" value="ID_final"/>
<parameter key="index_attribute" value="Dia semana"/>
<parameter key="skip_constant_attributes" value="false"/>
</operator>
<operator activated="true" class="aggregate" compatibility="8.2.000" expanded="true" height="82" name="Aggregate (2)" width="90" x="179" y="340">
<list key="aggregation_attributes">
<parameter key="Consumo_minutos" value="maximum"/>
</list>
<parameter key="group_by_attributes" value="Franjas|ID_final"/>
</operator>
<operator activated="true" class="pivot" compatibility="8.2.000" expanded="true" height="82" name="Franjas (3)" width="90" x="313" y="340">
<parameter key="group_attribute" value="ID_final"/>
<parameter key="index_attribute" value="Franjas"/>
<parameter key="skip_constant_attributes" value="false"/>
</operator>
<operator activated="true" class="concurrency:join" compatibility="8.2.000" expanded="true" height="82" name="Join" width="90" x="581" y="289">
<parameter key="remove_double_attributes" value="false"/>
<parameter key="use_id_attribute_as_key" value="false"/>
<list key="key_attributes">
<parameter key="ID_final" value="ID_final"/>
</list>
<parameter key="keep_both_join_attributes" value="true"/>
</operator>
<operator activated="true" class="concurrency:join" compatibility="8.2.000" expanded="true" height="82" name="Join (2)" width="90" x="648" y="391">
<parameter key="remove_double_attributes" value="false"/>
<parameter key="use_id_attribute_as_key" value="false"/>
<list key="key_attributes">
<parameter key="ID_final_from_ES2" value="ID_final"/>
</list>
<parameter key="keep_both_join_attributes" value="true"/>
</operator>
<operator activated="true" class="replace_missing_values" compatibility="8.2.000" expanded="true" height="103" name="Replace Missing Values" width="90" x="782" y="391">
<parameter key="attribute_filter_type" value="regular_expression"/>
<parameter key="regular_expression" value="maximum.+"/>
<parameter key="default" value="zero"/>
<list key="columns"/>
</operator>
<operator activated="true" class="rename" compatibility="8.2.000" expanded="true" height="82" name="Rename (2)" width="90" x="916" y="391">
<parameter key="old_name" value="maximum(Consumo_minutos)_Automóviles"/>
<parameter key="new_name" value="ANY_Autos"/>
<list key="rename_additional_attributes">
<parameter key="maximum(Consumo_minutos)_Accion" value="ANY_Accion"/>
<parameter key="maximum(Consumo_minutos)_Adultos" value="ANY_Adultos"/>
<parameter key="maximum(Consumo_minutos)_Animacion" value="ANY_Animacion"/>
<parameter key="maximum(Consumo_minutos)_Aventura" value="ANY_Aventura"/>
<parameter key="maximum(Consumo_minutos)_Baile" value="ANY_Baile"/>
<parameter key="maximum(Consumo_minutos)_Belleza" value="ANY_Belleza"/>
<parameter key="maximum(Consumo_minutos)_Box" value="ANY_Box"/>
<parameter key="maximum(Consumo_minutos)_Caricaturas" value="ANY_Caricaturas"/>
<parameter key="maximum(Consumo_minutos)_Ciclismo" value="ANY_Ciclismo"/>
<parameter key="maximum(Consumo_minutos)_Ciencia ficcion" value="ANY_Ciencia ficcion"/>
<parameter key="maximum(Consumo_minutos)_Cocina" value="ANY_Cocina"/>
<parameter key="maximum(Consumo_minutos)_Comedia" value="ANY_Comedia"/>
<parameter key="maximum(Consumo_minutos)_Concurso" value="ANY_Concurso"/>
<parameter key="maximum(Consumo_minutos)_Crimen" value="ANY_Crimen"/>
<parameter key="maximum(Consumo_minutos)_Deportes" value="ANY_Deportes"/>
<parameter key="maximum(Consumo_minutos)_Documental" value="ANY_Documental"/>
<parameter key="maximum(Consumo_minutos)_Drama" value="ANY_Drama"/>
<parameter key="maximum(Consumo_minutos)_Educativo" value="ANY_Educativo"/>
<parameter key="maximum(Consumo_minutos)_Entretenimiento" value="ANY_Entretenimiento"/>
<parameter key="maximum(Consumo_minutos)_Espectáculos" value="ANY_Espectaculos"/>
<parameter key="maximum(Consumo_minutos)_Familiar" value="ANY_Familiar"/>
<parameter key="maximum(Consumo_minutos)_Fantasía" value="ANY_Fantasia"/>
<parameter key="maximum(Consumo_minutos)_Futbol Soccer" value="ANY_Futbol"/>
<parameter key="maximum(Consumo_minutos)_Horror" value="ANY_Horror"/>
<parameter key="maximum(Consumo_minutos)_Infantil" value="ANY_Infantil"/>
<parameter key="maximum(Consumo_minutos)_Informativo" value="ANY_Informativo"/>
<parameter key="maximum(Consumo_minutos)_Investigación" value="ANY_Investigacion"/>
<parameter key="maximum(Consumo_minutos)_Lucha Libre" value="ANY_Lucha libre"/>
<parameter key="maximum(Consumo_minutos)_Melodrama" value="ANY_Melodrama"/>
<parameter key="maximum(Consumo_minutos)_Mundo animal" value="ANY_Mundo animal"/>
<parameter key="maximum(Consumo_minutos)_Musical" value="ANY_Musical"/>
<parameter key="maximum(Consumo_minutos)_Noticias" value="ANY_Noticias"/>
<parameter key="maximum(Consumo_minutos)_Publicidad" value="ANY_Publicidad"/>
<parameter key="maximum(Consumo_minutos)_Reality TV" value="ANY_Reality"/>
<parameter key="maximum(Consumo_minutos)_Religión" value="ANY_Religion"/>
<parameter key="maximum(Consumo_minutos)_Romance" value="ANY_Romance"/>
<parameter key="maximum(Consumo_minutos)_Serie Animada" value="ANY_Serie animada"/>
<parameter key="maximum(Consumo_minutos)_Serie Infantil" value="ANY_Serie infantil"/>
<parameter key="maximum(Consumo_minutos)_Series" value="ANY_Series"/>
<parameter key="maximum(Consumo_minutos)_Suspenso" value="ANY_Suspenso"/>
<parameter key="maximum(Consumo_minutos)_Terror" value="ANY_Terror"/>
<parameter key="maximum(Consumo_minutos)_Tv-show" value="ANY_Show"/>
<parameter key="maximum(Consumo_minutos)_Fin de semana" value="ANY_FS"/>
<parameter key="maximum(Consumo_minutos)_Entre semana" value="ANY_ES"/>
<parameter key="maximum(Consumo_minutos)_AAA" value="ANY_AAA"/>
<parameter key="maximum(Consumo_minutos)_AA" value="ANY_AA"/>
<parameter key="maximum(Consumo_minutos)_A" value="ANY_A"/>
<parameter key="maximum(Consumo_minutos)_ON" value="ANY_ON"/>
</list>
</operator>
<operator activated="true" class="set_role" compatibility="8.2.000" expanded="true" height="82" name="Set Role (4)" width="90" x="1184" y="391">
<parameter key="attribute_name" value="ID_final"/>
<parameter key="target_role" value="id"/>
<list key="set_additional_roles">
<parameter key="ID_final_from_ES2" value="id"/>
<parameter key="ID_final_from_ES2_from_ES2" value="id"/>
</list>
</operator>
<operator activated="true" class="store" compatibility="8.2.000" expanded="true" height="68" name="Store (4)" width="90" x="1318" y="391">
<parameter key="repository_entry" value="Offline data ok para clusters/any_para_cluster"/>
</operator>
<connect from_op="Retrieve anytime_partitioned_limpia" from_port="output" to_op="Select Attributes" to_port="example set input"/>
<connect from_op="Select Attributes" from_port="example set output" to_op="Generate Attributes" to_port="example set input"/>
<connect from_op="Generate Attributes" from_port="example set output" to_op="Generate Attributes (14)" to_port="example set input"/>
<connect from_op="Generate Attributes (14)" from_port="example set output" to_op="Nominal to Numerical" to_port="example set input"/>
<connect from_op="Nominal to Numerical" from_port="example set output" to_op="Generate Attributes (2)" to_port="example set input"/>
<connect from_op="Generate Attributes (2)" from_port="example set output" to_op="Nominal to Date" to_port="example set input"/>
<connect from_op="Nominal to Date" from_port="example set output" to_op="Date to Numerical" to_port="example set input"/>
<connect from_op="Date to Numerical" from_port="example set output" to_op="Numerical to Polynominal (4)" to_port="example set input"/>
<connect from_op="Numerical to Polynominal (4)" from_port="example set output" to_op="Map (5)" to_port="example set input"/>
<connect from_op="Map (5)" from_port="example set output" to_op="Select Attributes (2)" to_port="example set input"/>
<connect from_op="Select Attributes (2)" from_port="example set output" to_op="Rename" to_port="example set input"/>
<connect from_op="Rename" from_port="example set output" to_op="Multiply" to_port="input"/>
<connect from_op="Multiply" from_port="output 1" to_op="Aggregate (2)" to_port="example set input"/>
<connect from_op="Multiply" from_port="output 2" to_op="Aggregate" to_port="example set input"/>
<connect from_op="Multiply" from_port="output 3" to_op="Aggregate (3)" to_port="example set input"/>
<connect from_op="Aggregate (3)" from_port="example set output" to_op="Map" to_port="example set input"/>
<connect from_op="Map" from_port="example set output" to_op="Genero (2)" to_port="example set input"/>
<connect from_op="Genero (2)" from_port="example set output" to_op="Join (2)" to_port="right"/>
<connect from_op="Aggregate" from_port="example set output" to_op="Dayweek (2)" to_port="example set input"/>
<connect from_op="Dayweek (2)" from_port="example set output" to_op="Join" to_port="left"/>
<connect from_op="Aggregate (2)" from_port="example set output" to_op="Franjas (3)" to_port="example set input"/>
<connect from_op="Franjas (3)" from_port="example set output" to_op="Join" to_port="right"/>
<connect from_op="Join" from_port="join" to_op="Join (2)" to_port="left"/>
<connect from_op="Join (2)" from_port="join" to_op="Replace Missing Values" to_port="example set input"/>
<connect from_op="Replace Missing Values" from_port="example set output" to_op="Rename (2)" to_port="example set input"/>
<connect from_op="Rename (2)" from_port="example set output" to_op="Set Role (4)" to_port="example set input"/>
<connect from_op="Set Role (4)" from_port="example set output" to_op="Store (4)" to_port="input"/>
<connect from_op="Store (4)" from_port="through" 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"/>
<description align="center" color="yellow" colored="false" height="120" resized="false" width="180" x="1280" y="224">anytime</description>
</process>
</operator>
</process>Regards,
Lionel
0
Answers
Hi @sebastian_gonza,
Try to go in the menu :
Process --> Check Synchronize Meta Data with Real Data
If it is not working could you share your process and your dataset(s) ?
Regards,
Lionel
Not really an answer to your problem, but you can also use the rename by replaceming operator. This way you can use a regex to replace all your new names with the short one. Just replace maximum(Consumo_minutos)_ with ANY, and all matching columns are replaced at the same time. Easier than keeping track of all your possible options...
Hi @sebastian_gonza,
to share your data file you can :
- create a zip archive and share here in the forum.
OR
- post your file on a cloud repository (Google Drive for example) and share the link.
Regards,
Lionel
Ok, here in zip
thks
Thank you Lionel