How to pass diff attribute in group by attribute of aggregate operator as per config file iteration

sgnarkhede2016
sgnarkhede2016 New Altair Community Member
edited November 5 in Community Q&A
Hello,

I am building a profile on the different scenario like
Customer
Customer Beneficiary
Customer Beneficiary Risk Profile
These three combination present in my config file I want to build all scenarios one by one but don't know how to change select attribute runtime.

e.g.
In my first iteration select attribute is "customer" it works but in next iteration I want two attribute in select attribute "Customer" and "Beneficiary"

Please do needful

Answers

  • MPB_
    MPB_ New Altair Community Member
    Hey @sgnarkhede2016 ,

    could you please share your process? I am not sure if I understand you correctly.
  • sgnarkhede2016
    sgnarkhede2016 New Altair Community Member
    but we are fetching data from db
  • sgnarkhede2016
    sgnarkhede2016 New Altair Community Member
    Hello,

    For more clarification,

    We want to perform aggregation on a different parameter which will be pick up from config file.

    e.g.
    From the config file, it should pick up the first column on which aggregation has to be performed in our case which will be "customer"
    When it picks up next entry from config file there will be two columns on which aggregation will performed in our case which will be "Customer" and "Beneficiary"

    Is it possible to aggregate from the config file?


  • MartinLiebig
    MartinLiebig
    Altair Employee
    Hi,
    please make yourself comfortable with macros in RapidMiner: https://community.rapidminer.com/discussion/50538/how-to-use-macros

    what you want to do is to use, Read Excel (to read the config), Loop values annd inside a Aggreagte using the macro Loop values exposes.

    ~Martin

  • sgnarkhede2016
    sgnarkhede2016 New Altair Community Member
    Can you please give an example,
    Currently, we are passing macro in the select attribute but hardcoded we want to pass multiple macros as per the config file.
    We have already done a loop on Config then used aggregate operator but as per loop, we need change select attribute.
    Like in the first loop is only "Customer" in select attribute but next loop two attributes in select attribute "Customer" and "Beneficiary"