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
0
votes
1 answer

Append multiple excel files into one file but different sheets in KNIME

I have KNIME work flow which generates different worksheet, I want one single excel files with multiple sheets in KNIME workflow.
Hemant Kumar
  • 1,025
  • 15
  • 32
0
votes
1 answer

change values into missing in KNIME

I have a dataset in which I have N/A for each missing value, how can I change it into an actual missing value, inside the column itself. I've been trying with the Rule Engine node but it just doesn't work.. Any suggestion?
plastico
  • 61
  • 1
  • 11
0
votes
0 answers

Pagination in KNIME

How to mark pagination in the XPath node in KNIME when I have a button for "show more"?
Julian
  • 154
  • 1
  • 11
0
votes
1 answer

In Knime, how do I split rows that have multiline values in one cell, duplicating the rest of the cells?

I've loaded a spreadsheet (originally from Excel) into Knime, and it contains rows where cells in a particular column can have multiple values, separated by line breaks: I'd like to split them out so that each value is on it's own row, and that the…
Graham Evans
  • 23
  • 4
0
votes
1 answer

SQL server 2012 - convert sales order line data for knime market basket analysis

I am trying to read a table in knime for market basket analysis. To do that I need sales order line data from SQL server 2012 in this format: A single column with space concatenated items. Example: ordNo itemNo x a1 x c2 y a1 y b4 y …
Raymond Anderson
  • 81
  • 2
  • 13
0
votes
0 answers

How to Display Error Message in Batch Mode?

I am trying to execute KNIME.exe in (Windows 10) cmd/Python 3. But when there is an error message, I always get a pop-up window instead of displaying them in the cmd/Jupyter Notebook. Question: Is there any way I can see the error message directly…
Howell Yu
  • 73
  • 8
0
votes
1 answer

Error Execute Knime in Batch Mode: Unknown option '-workflow'

I am executing Knime in batch mode (win10 PowerShell) but I am having the following error: ERROR main BatchExecutor Unknown option '-workflow' ERROR KNIME-ConfigurationArea-Checker ConfigurationAreaChecker Can't check integrity of…
Howell Yu
  • 73
  • 8
0
votes
1 answer

How to import CSV to KNIME in command line

I want to import a CSV file to KNIME in command line. When I run a command line like this: "C:\Program Files\KNIME\knime.exe" c:\temp\foo.csv A dialog pops up, but the button is grayed, I can't click finish. I'm new to KNIME, just installed it,…
ZhenYu Wang
  • 1,077
  • 2
  • 11
  • 13
0
votes
1 answer

How to open or download an excel file with Knime from SharePoint?

I have a corporate SharePoint platform of course and I want to: -Open or download-to-soon-modify some Excel files -Download and upload files after some changes Or, is there a way for getting Knime to retrieve data from SAP GUI? But I don´t get how…
user3412266
  • 71
  • 1
  • 3
  • 8
0
votes
1 answer

How to connect a Firebird data base with Knime?

I need connect my Firebird data base (.IDB) in KNIME. I used Database Connector node, but I have this notice: ERROR Database Connector 0:1 Execute failed: Could not create connection to database: Invalid connection string …
Cristian Villota J
  • 1
  • 1
0
votes
0 answers

KNIME: How to properly use Auto Binner

I want to create 10 different Bins with a table I already have, But when I use it, some cells appear with the sign of [ ? ] instead of a bin, for example RSI RSI (BINNED) 58.82 (55.846,59.405] 68.43 ? 65.2 ? 72.18 ? 72.29 ? 71.69 …
Rodrigo Zazueta Donnadieu
  • 55
  • 7
0
votes
1 answer

Knime HDFS connection node not working

Objective: load csv to a hive/impala/hdfs table Tools: Knime Scenario: I am using table creator ( just 1 row with 1 value), HIve connector( this connects to host without issues), HDFS connection and hive loader. When I configure HDFS connection…
DrSD
  • 151
  • 2
  • 12
0
votes
1 answer

Plot total number of users by date joined

Is there any function or node which will add the number of elements in a set chronologically? I would like to create a simple line graph of "total number of users" over time, but what I have is "user_email" (unique) and "date_created" for the date…
dsaves
  • 181
  • 8
0
votes
1 answer

How do I extract the row id column from Bayes predictor in KNIME?

I have the following classified data from my naive Bayes predictor. I want to be able to export it into a excel file. I've tried using a a Excel writer node and also tried just copying and pasting the data, but both of them seem to ignore the row…
yfan183
  • 547
  • 2
  • 7
  • 20
0
votes
0 answers

Bad Authentication data. code - 215 using Knime

I've tried to config a "Twitter API Connector" and then exec "Twitter Search" but I received below error: ERROR Twitter Search 2:2 Execute failed: 400:The request was invalid. An accompanying error message will explain why. This is …
Mehrdad
  • 41
  • 1
  • 1
  • 4
1 2 3
…
19 20