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

Selecting attributes and renaming them dynamically using mapping in Excel file

achint_kumarachint_kumar Member Posts: 16 Contributor II
edited March 2021 in Help
Hi RM Family, hope everyone is doing safe!

Not sure if its possible but we are trying to automate a QC process wherein we need to dynamically select attributes and rename them with respect to a mapping file. I am trying to avoid creating different QC process for each report.

PFAttached below screenshot for your reference. Highlighted in Yellow are the columns that needs to be selected, while highlighted in Orange is to be renamed. We need to select these in a loop for each KPI Name(Column 1)Also Please find attached process developed till now, everything is dynamic except selecting attributes and renaming them as per mapping file above. Looking forward to hearing from you all. :smile:

Answers

  • MarcoBarradasMarcoBarradas Administrator, Employee-RapidMiner, RapidMiner Certified Analyst, Member Posts: 272 Unicorn
    Hi @achint_kumar you could use a loop attributes that include the columns you need to change and with some macros and an example set with the excel file you could filter, gather the name and put it on a rename operator passing the macro of the loop attribute and the macro with the new name.


Sign In or Register to comment.