since I am knew here, I have some issues building a workflow. I have difficulties sorting my data inside a column. It is a column with numbers, where numbers are going from 9 to 30. Every time when I sort them it takes a 10 as a smallest value, followed by 11, 12, 13 etc. and then sort the number 9 as a biggest value. It looks like this:
and what I want is:
and I am also interested in a node which would allow me to sort information inside one column by mine own criteria, so that the order of Information inside one column are done by user preferences. Is there such a node?
Thank you very much
welcome to KNIME Community!
I would say your column is type String and that is reason behind output you are seeing. To get your desired output you first need to convert your column to number column using String to Number node.
As for node to define your own sorting criteria. To my knowledge there is no such node but if you give us an example how this would look like and reasons behind it maybe we can figure out something.
thank you for your quick response. I did it via String to number and it worked just fine, but when I wanted to visualize the data via histogram and assign a colour to a number I could not because it would be shown as a range, and the lowest values has like colour red and the highest one has a blue.
But nevertheless, what I am trying to do is to sort data so that in the end i got them like sorted hierarchically like phylogenetic tree.
I have families of certain transporters and every family has a subfamily. There are structures that bind to certain transporter. The idea is to have a families like main group branching into corresponding subfamilies, branching to compounds that are binding to them, branching to a certain value which is specific tot that compound.
I managed to get something that resemble to the phylogenetic tree using a parallel coordinates plot, but still my families and subfamilies are not ordered in a way that i want them to be, so the plot itself resemble to the phylogenetic tree but it is not the one.
i would like to have them like
R1 branches to R1.1
R2 branches to R2.1
instead i have
(there is a name and a number of a certain transporter)
Hmm. Assigning color to a number and then displaying it with histogram? You can use Number To String prior to assigning colors and doing visualizations. (Know it is a bit back and forth )
Regarding phylogenetic tree. Seems to me it is not a bad idea to use Parallel Coordinates Plot to simulate it. You need to have each (sub)family in one column for it and properly sort, right? Have an idea how this could be done but manipulations (nodes) depend on data set. If you share sample (dummy is just fine as long as it represent the real one properly) I can give it a go.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.