Missing id attribute after pivot operator

SabrineSabrine MemberPosts:2Contributor I
edited November 2018 inHelp

Hi everyone,

I am having the problem that I can no longer access the Id-attribute after using the pivot operator. Although the ID-attribute is shown under the pivot operator info, trying to get hold of it, for example using the set role or select attribute operator would result in an "Attribute not found " type of error. It should be noted that the ID attribute was used as the group attribute for pivoting.

I have searched the forum and found a similar post from 2012 but about another operator, the "windowing operator". The problem seems to be identical. The contributor noticed that the problem can be avoided by changing the role of the ID-attribute before applying the operator and this has also worked for me! The problem can be avoided this way but I wanted to clarify it properly by posting it on this forum .

The type of the Id-attribute in my case is integer, in the range [ 66612-75613] (not continuously). In the tutorial data example for the pivot operator as well as in the case of other Id-attributes examples the problem did not occur!

would be thankful for your help,

Sabrine

Tagged:

Best Answer

  • landland RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:2,531Unicorn
    Solution Accepted

    Hi Sabrine,

    that's funny. I didn't know that...From a glance of that it seems there's a glitch in RapidMiner handling the numerical id attribute used as group.

    @mschmitzIs there a way to mark posts here as bug? So that you can resolve them?

    The solution in this case is simple: Use Set Role before pivoting to set it back to regular. Then after pivoting you can set it again on role id. Should solve your isse.

    The below process hows the issue and the solution:






    <宏/ >








    <参数键= " attribute_name " value = " id " / >























Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University ProfessorPosts:3,385RM Data Scientist

    Sebastian,

    thanks for providing this solution. I am not sure about the forums and bug tracker.@stevefarrcan you help please?

    ~martin

    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • SabrineSabrine MemberPosts:2Contributor I

    Hi Sebastian,

    Thank you for your reply. The issue is solved this way, this is also what the contributor who had a similar problem (with the windowing operator) did and it works perfect! I already had the feeling that this might be a bug since it seemed so strange to see the id-attribute in the operator-output but not to be able to get hold of it afterwards.

    Sabrine,

Sign InorRegisterto comment.