Missing id attribute after pivot operator
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,