Pivot node not working correctly?

[GoogleCodeExporter]

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?

Original issue reported on code.google.com by gbon...@gmail.com on 11 May 2009 at 9:52

Attachments:

• resulttable.tsv

[GoogleCodeExporter]

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.

Original comment by aborgabor on 12 May 2009 at 8:01

• Added labels: Component-Docs, Type-Other
• Removed labels: Type-Defect

[GoogleCodeExporter]

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.

Original comment by aborgabor on 12 May 2009 at 8:55

[GoogleCodeExporter]

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.

Original comment by aborgabor on 14 May 2009 at 11:13

• Changed state: Accepted

[GoogleCodeExporter]

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.

Original comment by gbon...@gmail.com on 14 May 2009 at 5:16

[GoogleCodeExporter]

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.

Original comment by aborgabor on 15 Oct 2009 at 12:15