My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 21: Pivot node not working correctly?
1 person starred this issue and may be notified of changes. Back to list
Status:  Accepted
Owner:  aborgabor


 
Reported by gbon...@gmail.com, May 11, 2009
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?
resulttable.tsv
536 KB   View   Download
May 12, 2009
Project Member #1 aborgabor
This error message tells you that you have to compute the domain of the column. You
can use the Domain Calculator node to achieve this state.
Labels: -Type-Defect Type-Other Component-Docs
May 12, 2009
Project Member #2 aborgabor
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
Project Member #3 aborgabor
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
#4 gbon...@gmail.com
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.

Powered by Google Project Hosting