Group by or Aggregate? for non numerical attributes

User: "LilC"
New Altair Community Member
Updated by Jocelyn
Hi Guys, me again, the newbie of RapidMiner.
There are 4 cities in the dataset and each city has multiple stores.
And I want to somehow group by the stores with the individual city.
Instead of:
City A, Store1
City A, Store2
City A, Store3
City B, Store4
....

I kinda want to have a form of: 
City A, Store 1
            Store 2
           Store 3
City B, Store 4
....

I hope it makes sense.
Could anyone help me with if there is an operator could achieve this?

Thanks again.

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "MartinLiebig"
    Altair Employee
    Accepted Answer
    Hi @LilC,
    do i see this correctly, that you want to remove the Value in case the proceeding one is the same?
    In this case i would use Lag, to create a shifted city attibute (City-1). Then you can use Generate Attributes with

    if(City==[City=1],MISSING_NOMINAL,City)

    I hope this helps!
    cheers,
    Martin