Regular attributes can't be addressed by an operator after Transposing
JohnnyRapid
Member Posts: 9 
Contributor II
The issue is, that after using the "transpose" operator, the operator "select attributes" doesn't confirm the new "attribute".
In the result view it shows me, that there is 1 special attribute (ID) and over 2000 regular attributes. These regular attributes cannot be addressed by an operator. There is only the ID which I can adresse with an operator.
Thank u for ur help
Jonathan
Best Answer
-
MartinLiebig
Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 
RM Data Scientist
Hi @JohnnyRapid,
the answer is very simple. We cannot get the meta data of the attribute names in a transpose. You would need to know all values in the data in order to do. That's why transpose is not using default meta data propagation. You can still just type in the names of your attribute in the window to run this.
Another option would be to use Process -> Synchronize Data with Real Data and run the process once. You should see the attributes afterwards.
Cheers,
Martin
- Sr. Director Data Solutions, Altair RapidMiner -
Dortmund, Germany2
Answers
hello @JohnnyRapid welcome to the community! I'd recommend posting your XML process here (see https://youtu.be/KkgB5QXWXJ8 and "Read Before Posting" on right when you reply) and attach your dataset. This way we can replicate what you're doing and help you better.
Scott
Hi @sgenzer,
thank u for ur quick reply. Unfortunately I can't post the code, because it is a consulting manadat.
But Maybe I can create the same error with an open Project, so that I can poste the XML
Jonathan
The XML:
<operator activated="true" class="append" compatibility="8.1.000" expanded="true" height="103" name="Append" width="90" x="1251" y="34"/>
<operator activated="true" class="transpose" compatibility="8.1.000" expanded="true" height="82" name="Transpose" width="90" x="1385" y="34"/>
<operator activated="true" class="select_attributes" compatibility="8.1.000" expanded="true" height="82" name="Select Attributes (15)" width="90" x="1519" y="34"/>
<connect from_port="in 1" to_op="Set Role (9)" to_port="example set input"/>
<connect from_port="in 2" to_op="Reorder Attributes (3)" to_port="example set input"/>
<connect from_op="Set Role (9)" from_port="example set output" to_op="Reorder Attributes (2)" to_port="example set input"/>
<connect from_op="Reorder Attributes (2)" from_port="example set output" to_op="Remove Duplicates" to_port="example set input"/>
<connect from_op="Remove Duplicates" from_port="example set output" to_op="Multiply (2)" to_port="input"/>
<connect from_op="Multiply (2)" from_port="output 1" to_op="Reorder Attributes (4)" to_port="example set input"/>
<connect from_op="Multiply (2)" from_port="output 2" to_op="Select Attributes (11)" to_port="example set input"/>
<connect from_op="Select Attributes (11)" from_port="example set output" to_op="Union (2)" to_port="example set 2"/>
<connect from_op="Reorder Attributes (4)" from_port="example set output" to_op="Append" to_port="example set 1"/>
<connect from_op="Reorder Attributes (3)" from_port="example set output" to_op="Union (2)" to_port="example set 1"/>
<connect from_op="Union (2)" from_port="union" to_op="Filter Examples" to_port="example set input"/>
<connect from_op="Filter Examples" from_port="example set output" to_op="Append" to_port="example set 2"/>
<connect from_op="Append" from_port="merged set" to_op="Transpose" to_port="example set input"/>
<connect from_op="Transpose" from_port="example set output" to_op="Select Attributes (15)" to_port="example set input"/>
<connect from_op="Select Attributes (15)" from_port="example set output" to_port="out 1"/>
<portSpacing port="source_in 1" spacing="0"/>
<portSpacing port="source_in 2" spacing="0"/>
<portSpacing port="source_in 3" spacing="0"/>
<portSpacing port="sink_out 1" spacing="0"/>
<portSpacing port="sink_out 2" spacing="0"/>
</process>
</operator>
<connect from_op="Retrieve DatenProzessInput" from_port="output" to_op="Subprocess" to_port="in 1"/>
<connect from_op="Subprocess" from_port="out 1" to_op="Numerical to Polynominal" to_port="example set input"/>
<connect from_op="Numerical to Polynominal" from_port="example set output" to_op="Set Role" to_port="example set input"/>
<connect from_op="Set Role" from_port="example set output" to_op="Rename by Replacing" to_port="example set input"/>
<connect from_op="Rename by Replacing" from_port="example set output" to_op="Reorder Attributes" to_port="example set input"/>
<connect from_op="Reorder Attributes" from_port="example set output" to_op="Multiply" to_port="input"/>
<connect from_op="Multiply" from_port="output 1" to_op="Decision Tree Model" to_port="in 1"/>
<connect from_op="Multiply" from_port="output 2" to_op="True False" to_port="in 1"/>
<connect from_op="Eingabe Rezept" from_port="out 1" to_op="Decision Tree Model" to_port="in 2"/>
<connect from_op="Decision Tree Model" from_port="out 1" to_op="Generate Attributes (2)" to_port="example set input"/>
<connect from_op="Generate Attributes (2)" from_port="example set output" to_op="Select Attributes (13)" to_port="example set input"/>
<connect from_op="Select Attributes (13)" from_port="example set output" to_op="Set Role (14)" to_port="example set input"/>
<connect from_op="Set Role (14)" from_port="example set output" to_op="TrueFalsTransponiert" to_port="in 2"/>
<connect from_op="True False" from_port="out 1" to_op="TrueFalsTransponiert" to_port="in 1"/>
<connect from_op="TrueFalsTransponiert" from_port="out 1" to_port="result 1"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
<portSpacing port="sink_result 2" spacing="0"/>
</process>
</operator>
</process>
And I would like to use the "select Attriubte" Operator ah the end. Unfortently the operator can't adresse the regular attributes genrated through the operator "transpose".
@JohnnyRapid please use the </> code block button. Your XML code is at risk for corruption from symbols that may be parsed as emojis.
Just like this:?
Hi @JohnnyRapid,
It seems there is a problem with your XML code : It cannot be loaded : Can you verify it ?
Click in the XML panel -> Ctrl + A (to select the whole process) -> Ctrl + C -> then paste it
Regards,
Lionel
Just copied a piece of it...now it is the whole XML:
Hi again Jonathan,
It's a huge process......
Can you attach your different datasets in order we can run the process and so reproduce the error.
Regards,
Lionel
Hi @mschmitz,
thanks a lot. That explains it in an easy way. I will check if it is possible to "Synchronize Data with Real Data" otherwise I would do a Workarround and use the "Write" and "read" Excel operator.
Best
Jonahan