| Issue 21: | Pivot node not working correctly? | |
| 1 person starred this issue and may be notified of changes. | Back to list |
What steps will reproduce the problem?
1.Load table
2.Pivot
3.
What is the expected output? What do you see instead?
A table with the pivoted rows.
What version of the product are you using? On what operating system?
Please provide any additional information below.
I try to pivot the attached table.
Paramters for Pivot used: Pivot COlumn=ObjectIndex
Pattern: ${ObjectIndex}-${}
Behavior: fillEmpty
I receive the following warning and cannot evaluate the node:
WARN Pivot Not a nominal column: ObjectIndex
WHat am I doing wrong?
May 12, 2009
Project Member
#1
aborgabor
Labels:
-Type-Defect Type-Other Component-Docs
May 12, 2009
Please also note that the result might be not satisfactory for you. You have to reorder your data to have the values in the ObjectIndex in ascending order for each group. (Actually I do not know how to do this in KNIME. This might be a good new feature to support.) In this case it creates too many groups and not what you might want.
May 14, 2009
I am going to create the node for reordering this kind of data do you have any ideas what are the important features of it? Do you see other solutions to this problem? PS.:It might be useful if questions like this would go to the user's forum (http://groups.google.com/group/HiTSusers). If you want we can continue our discussion there.
Status:
Accepted
Owner: aborgabor
May 14, 2009
I had typped an answre but somehow it seems that it has now disappeared. I am moving this to the user forum as per your request.
Oct 15, 2009
Could you check whether the examples, descriptions are interpretable, clear? You can find them here: http://hits.googlecode.com/svn/ie.tcd.imm.knime.util/trunk/ie.tcd.imm.knime.util/html/nodes/Unpivot.html http://hits.googlecode.com/svn/ie.tcd.imm.knime.util/trunk/ie.tcd.imm.knime.util/html/nodes/Pivot.html Thanks. |