Forum & Documentation

User login

KNIME Users

For users of the KNIME Data Analysis Workbench

Cartesian joins...

...are very cumbersome to implement right now. It'd be nice if you could consider them for the new version of the joiner node, if you haven't already. :-)

Thanks,
E

Decision Tree Options

Hello Everyone,

I have Problems in understanding what the Options of the Decision Tree exactly do. I have already read the Descriptions of the Decision Tree Learner and Predictor and i didnt get smarter of it (bad english!). And i have already tried to unterstand by comparing the results created with different Options.

Please u must help me out:

What does 'Average Split Point', Binary nominal splits and Max #nominal do?

Maybe it would help if someone can tell me that in german.

Thanks in advance

helpless User

DNS lookup with KNIME

Dear KNIMErs,

I'd like to do a series of (automated/looped) DNS lookups with KNIME - any ideas of how I could go about doing that?

Many thanks,
E

Using Create Collection Column node with variable column names

Hi,

I'm trying to use the collection column to iterate over all columns in a table.
I create a collection, operate on it using the Java snippet to return a new array, and
then split back into the original columns.
This works, but the 'Create Collection Column' node needs to be reconfigured when
new data with different column names is passed. This is inconvienent when running in a loop.
Is it possible to have 'use all columns' option, or similar?

Thanks

Dave

Group by max option for dates, and maybe a range as well

Dear KNIMErs,

Long time no see, sorry - I'm awfully busy lately. However, I've been using KNIME quite intensively again the last days, and now I'm missing a feature. Shouldn't it be possible to select the "Max" (or "Min") option for date values in the "Group by" node?

Having said that, a possibility of calculating the range of any numeric variable, or the days between in case of date variables, would be most useful as well. :-)

Any comments of the ease of implementing this, particularly the first request?

Many thanks,
E.

How to convert int to string?

Hi,

I have some troubles converting a int to string:

String holiday = new String($Date$);

I get the error message: "Cannot find symbol :constructor String(int)"

Could you please help me with this issue.

regards,

Schlirgg

How to use Rows in Java Snippet dynamically

Hi,

How can I use Rows in Java Snippet dynamicaly?

As example:

/* Please note that as of KNIME 2.0
* you must use the "return" keyword
* to specify the return value.
*/
double result=0;
String strTest="";
for ( int i = 1; i <= $$ROWCOUNT$$; i ++ ) {

/* change Row dynamically=>How? */
strTest="Row"+i;
result= $strTest$+$Row1$;

}

return result;

Regards,

Schlirgg

Merge Tables with different number of rows.

Hi, I´m a new user for Knime.

First at all, I excuse for my english, I speak spanish. I have the same problem that other users. How can I merge two tables where each one has a different number of rows? Here is an example of what I try to do:

TABLE 1
Brand Qty Month
Toyota 1 Jan
Chevrolet 3 Jan
Chevrolet 4 Jan
Hyundai 4 Jan
Renault 4 Jan
Renault 1 Feb
Mazda 1 Mar
Renault 8 Mar
Renault 9 Mar
Renault 0 Apr
Renault 6 Apr
Hyundai 5 Apr
Chevrolet 4 Apr
Chevrolet 2 May
Chevrolet 1 May
Chevrolet 1 May
BMW 2 May
BMW 3 Jun

TABLE 2
Brand Sold by
Chevrolet John
BMW Mack
Hyundai Peter
Mazda Ross
Renault Judy
Toyota Caroline

I need to merge this two tables to have in the TABLE 1 the person who sold the vehicle. Then, the result that I need is:

Brand Qty Month Sold by
Toyota 1 Jan Caroline
Chevrolet 3 Jan John
Chevrolet 4 Jan John
Hyundai 4 Jan Peter
Renault 4 Jan Judy
Renault 1 Feb Judy
Mazda 1 Mar Ross
Renault 8 Mar Judy
Renault 9 Mar Judy
Renault 0 Apr Judy
Renault 6 Apr Judy
Hyundai 5 Apr Peter
Chevrolet 4 Apr John
Chevrolet 2 May John
Chevrolet 1 May John
Chevrolet 1 May John
BMW 2 May Mack
BMW 3 Jun Mack

I saw other post about similar topic, but I can´t find the way to do that. I try to use de Joiner combined with the RowID but it does not work. Thats because in the main table (TABLE 1), the column that I use to join is Brand and this column has some items with the same value (i.e. Renault).

How can i do this?

Thanks in advance for your help,

Luis

Problems using Naive Bayes Learner and Predictor.

I have to classify proteins based on characteristics such as hydrophilicity. I am unable to use properly Bayes' blocks, and I'm not able to find useful examples. Also, to train the learner block, we have text files, each containing informations for a single protein. Is it possible to combine them into a single matrix (with knime)?
Thanks in advance,
Michele

Workflow variables set on command line

Hi,
Is it possible to set the value of a workflow variable on the command line when starting KNIME in batch mode? And if so how can I do this?

Thanks,

Bernd