🎉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

Selecting attributes and renaming them dynamically using mapping in Excel file

User: "achint_kumar"
New Altair Community Member
Updated by Jocelyn
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:

Find more posts tagged with

Sort by:
1 - 1 of 11
    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.