Newbie with problems

KNIME Analytics Platform
1

Hello to all Kmine users.

I'm currently evaluating KMine and I would like to ask a few questions.

I have started using the folowing file (both Excel and CSV) to get familiar with the Kmine nodes.

Var1 Var2 Var3
5.000 1 4.00
9.225 1 4.00
11.845 1 2.00
15.710 1 2.00
18.450 1 4.00
22.497 1 2.00
33.825 1 4.00
36.450 1 2.00
45.000 1 4.00
48.585 1 4.00
58.523 1 3.00
65.650 1 2.00
70.000 1 4.00
73.800 1 4.00
80.000 1 4.00
80.000 1 4.00
81.840 1 2.00
82.250 1 4.00
85.000 1 4.00
94.350 1 2.00
98.400 1 4.00
100.000 1 4.00
109.792 1 4.00
109.792 2 1.00
123.000 1 4.00
123.000 2 4.00
125.262 1 2.00
125.928 1 2.00
132.510 1 1.00
132.510 2 2.00
134.876 1 2.00
136.383 1 2.00
140.000 1 4.00
140.000 1 4.00
140.000 1 4.00
140.000 1 4.00
148.000 1 4.00
150.000 1 4.00
150.000 3 4.00
153.750 1 4.00
162.980 1 2.00
163.066 1 2.00
167.092 1 2.00
167.860 1 2.00
176.556 1 2.00
177.349 1 2.00
184.130 1 2.00
185.000 1 2.00
186.100 1 4.00
186.100 2 4.00
186.100 3 4.00
186.100 4 4.00
186.100 5 4.00
186.100 6 4.00
186.784 1 2.00
200.000 1 1.00
215.000 1 1.00
216.000 1 2.00
224.588 1 2.00
234.000 1 1.00
244.865 1 2.00
246.765 1 2.00
250.000 3 4.00
251.307 1 2.00
257.147 1 2.00
259.766 1 2.00
266.662 1 2.00
267.013 1 2.00
271.000 1 2.00
271.500 1 2.00
272.980 1 2.00
274.025 1 2.00
274.254 1 2.00
285.094 1 2.00
289.120 1 2.00
293.461 1 2.00
319.273 1 1.00
324.820 1 2.00
328.945 1 2.00
329.796 1 1.00
338.740 1 2.00
338.740 2 3.00
345.940 1 2.00
350.140 1 2.00
361.000 1 3.00
375.150 1 3.00
383.443 1 1.00
383.443 2 2.00
 

I've tried sort it using the Sorter Node. I had no luck. Data remain unsorted. I've tried selecting rows based on Var2, Var3. Again no luck. I've tried aggregating using colums var2 and var3. Again no luck.

Could someone out there point me to the right direction. Because I'm obsiously doing something wrong.

 

Thank you in advance !!

 

2

When importing the csv or xls file using the approporiate nodes, did you select

 

table  contains columns names in row [1] in xls reader and has column header in csv reader? If not then the values will be read as strings, not double or integers and will not be sorted as you would expect.

3

Yes I did that.  I even checked the same option when using the XLS Reader node.

I also used the StringToNumber converter at some point. Still no luck.

What I get using the Column Aggregation node, after selecting in Aggregation Column(s) section Var1 and asking Count and Sum as the aggregation functions, is 1 for count and the same value as var1 per line for sum. I even tried sorting the rows by var2 and var3

4

No such issues for me. Why don't you import and run attached workflow. Each column can be sorted in turn or you can sort one after the the other in any sequence by adding additional sorting columns in the node

5

Thank you so much.

I've tried your solution and got a head start

6

Is there a node to derive a new column based on some kind of formula, ie (Var1/2)+3*Var2? I've search through the Data Manipulation nodes and I could find such.

Thank you in advance

7

Math Formula or Java Snippet. 

 

Sam