Map Operator isn't working with Aggregation Operator

Ellie98

Hello, 

I calculated the average value of each product with the Aggregation operator. 

I got those values: 

Now I'm trying to categorize 2 products together. Wines and Meat, Fish and Gold, Fruits and Sweets, like this: 

I want to visualize all 3 categories in the Pie Plot Type but if I run this process I still only get all averages of each product. Why isn't the mapping operator working? Do I have to save the aggregated attributes first? with apply model or something? 

Thanks in advance!!

BalazsBaranyRM

Hi!

No, you won't be able to create duplicate names with Rename by Replacing either. 

You could rotate the example set with Transpose so that attributes become values. Then you could use Map for renaming the averages. 

Regards,
Balázs

Caperez

Hi, @Ellie98, 

the Map operator works with values (rows) over the Attributes. To change the Attribute (column) name you need to work with Rename Operator.

Best

Ellie98

Hey @ceaperez,

Thank you for your answer. It says that I can't use the same name 2 times. 

Do I have to use Rename by Replacing instead? I'm not sure how that one works. 

BalazsBaranyRM

Hi!

No, you won't be able to create duplicate names with Rename by Replacing either. 

You could rotate the example set with Transpose so that attributes become values. Then you could use Map for renaming the averages. 

Regards,
Balázs

Ellie98

Thank you so much @BalazsBarany! It worked 😁👍