Stack Overflow
Stack Overflow

Questions tagged [knime]

KNIME (Konstanz Information Miner) is a user-friendly graphical workbench for the entire data analysis process.

KNIME is an open-source data analysis software, with various plugins from different areas. It has plugins from text mining to image processing, including the chemical structures and high throughput experiments.

KNIME Desktop is available for Windows, Mac and Linux under GPL v3 (or a custom license).

KNIME stands for Konstanz Information Miner and can be run on a centralized server with an integrated web interface or as standalone Rich Client. The client is based on the Eclipse Platform with the plugin and update mechanism. KNIME also offers job scheduling.

297 questions
1
vote
2 answers

How do I replace values in a column in KNIME?

I have a column of countries with 50 different values that I want to reduce to United States and Other. Can someone help me with that? Another example is Age which has 48 values that I'd like to reduce to only 4 like 1 to 18 = youth, 18-27 =…
Raymond Anderson
  • 81
  • 2
  • 13
1
vote
0 answers

KNIME does not create TEMP table

I have tried to create TEMP table using "Database SQL Executor" node using expression: CREATE TEMPORARY TABLE tmp_table AS SELECT type_id, created_at FROM t1 LEFT JOIN t2 ON t1.id = t2.id WHERE t2.id = (SELECT id FROM t2 WHERE id = t1.id AND…
nervuzz
  • 416
  • 3
  • 10
1
vote
2 answers

KNIME missing value node does not work

I'm running KNIME to prepare some ML data sets. It is about ecommmerce transactions where a association rule analysis should be done later. But my current problem is rather simple, I am in a 'data preparation step' where the missing value node in…
Marco P.
  • 81
  • 5
1
vote
1 answer

Dynamic String Manipulation in Knime

I want to dyanamically change my URL at runtime for which I did string manipulations in R and it worked with this script: x <- 'https://news.google.com/search?q=' var <- 'NREGA' z <- '&hl=en-IN&gl=IN&ceid=IN%3Aen' url <- paste0(x, var,z, collapse =…
user8589390
  • 49
  • 6
1
vote
1 answer

How to import R code in Knime

I want to import an R code which is basically the new articles from a website and saving the result in a dataframe. Now i want to import that dataframe directly into KNIME with the help of R nodes.
user8589390
  • 49
  • 6
1
vote
0 answers

Knime R snippet knime.out: 0 rows, n columns (with column names), node output: empty table, 0 rows and 0 columns

If I have an R snippet node in Knime, which (under some circumstances) produces an empty dataframe as knime.out with some columns. E.g. dataframe called df with column names "Col1", "Col2", "Col3", issuing command knime.out produces output: [1]…
oszkar
  • 865
  • 5
  • 21
1
vote
1 answer

KNIME: Error while creating node dialog for 'File Reader'

when I try to use a File Reader I have (often) this error Error while creating node dialog for 'File Reader': URI is not hierarchical. Do you have any idea of what is causing this problem? Thank you very much Here is my log: 2018-01-09 18:50:31,599…
Luca Monno
  • 830
  • 1
  • 11
  • 25
1
vote
1 answer

How to get Twitter data into KNIME for sentiment analysis

Here is what I tried, with the following result: ERROR Twitter Search 0:2 Execute failed: 401:Authentication credentials (https://dev.twitter.com/pages/auth) were missing or incorrect. Ensure that you have set valid consumer…
Mandava Geethabhargava
  • 11
  • 5
1
vote
1 answer

Knime List Files node regex filter broken on \+ (plus character)

In the List Files node applying regular expression filter .*\+.* or .*[+].* was working perfectly in Knime 3.3.2 (Windows 7, 64 bit). I have right now upgraded to 3.4.2, and it creates empty table on the same directory with files having '+' sign…
oszkar
  • 865
  • 5
  • 21
1
vote
1 answer

How to require/assert a condition in KNIME?

If I want to specify preconditions on the input arguments, what is the idiomatic way when developing KNIME nodes? Using assert(condition, message) might be efficient and simple, thought its check depends on the VM argument -ea. Manually checking…
Gábor Bakos
  • 8,982
  • 52
  • 35
  • 52
1
vote
1 answer

Does original database change in knime

When using the database manipulation nodes, does the original database data would change or remain the same? Can anyone answer please?
Uma Ramya
  • 11
  • 1
  • 5
1
vote
0 answers

Error ggplot and ggQC: No geom called label in R with KNIME

Here my problem, i use library ggplot2 for displaying a graph which use quality control charts. I'm using Knime, precisely R snippet for using my code. When i evaluate my script with R snippet Knime, I have this error : Error : No geom called…
R.Bun
  • 71
  • 1
  • 8
1
vote
1 answer

CREATE command denied to user in Knime database writer node

In a new KNIME workflow. I created a new database connection node and a new Database Writer node that accepts its data from a CSV reader node. The execution of the database connection node is successful. When I execute the Database writer node, I am…
mtleis
  • 712
  • 1
  • 9
  • 28
1
vote
1 answer

Getting tag association in KNIME

KNIME comes with several native nodes for performing different tagging tasks, like POS tagging or named entity recognition. In order to use the identified tags or terms, you can use the Bag of Words node, which produces terms (not words) and…
peleitor
  • 459
  • 7
  • 24
1
vote
1 answer

How to group row with unique value in knime?

I am interested in data science and I am quite new to knime. I have a question about the grouping the data in Excel. I have an xlsx file with two columns. in the xlsx file there is information about 2000 people. This informations titles are in the…
t.ztrk
  • 99
  • 1
  • 9
1 2 3
…
19 20