Example Set Transpose to Attribute Names

mikedmiked Member Posts: 21 Contributor II
edited February 2021 in Help
Hi All,
  Hoping I'm missing the simple answer here but I'm trying to transpose an aggregated set of data (Sales Months) to be Attribute Names (trying to make this dynamic as the number of months varies from data set to data set). below is a screenshot of current view.  I attempted to "Rename by Example Set" but ended up with an error. I assume it's from trying to make a date the attribute name when it is set up as a Nominal. Any ideas would be appreciated from the community. 


Best Answer

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,503 RM Data Scientist
    Solution Accepted
    Hi @miked ,
    i am a bit confused about what you want? Likely you want the Sales_Month as column Names?
    If so, try to set it to Role ID and then use the Transpose operator. Maybe you want to convert your dates into Nominals first.

    Cheers,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany

Answers

  • mikedmiked Member Posts: 21 Contributor II
    @mschmitz
    Hi Martin - Yes - I would like to use the Sales_Month as a column name and then perform some calcs that are month specific....Then de-pivot the data back together in stacked from. I will give your sugggestion a try thank you. 

    -Mike
Sign In or Register to comment.