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

sgnarkhede2016

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

Find more posts tagged with

AI Studio

Aggregate

Accepted answers

All comments

MPB_

Hey @sgnarkhede2016 ,

could you please share your process? I am not sure if I understand you correctly.

sgnarkhede2016

but we are fetching data from db

sgnarkhede2016

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

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

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"