CODEWITHSUNDEEP
mysqlsqlvariablesparameter-passingknime
user3796053
user3796053

Reputation: 11

passing a variable to SQL statement in KNIME

Using KNIME, I would like to analyze data in a specific subset of columns in my database but without using limiting SQL queries such as

Select * From table Where name like 'PAIN%'

Is there a way to do this in KNIME?

Upvotes: 1

Views: 1744

Answers (3)

Anupam Rekha
Anupam Rekha

Reputation: 186

the knime did not support like for now, so I used the mysql locate or FIND_IN_SET function

SELECT id FROM address where LOCATE($street_Arr[0]$,street) > 0

SELECT id FROM address where FIND_IN_SET($street_Arr[0]$,street) > 0

however in the same situation u might be able to use knime joins much faster.

Upvotes: 0

InformationEntropy
InformationEntropy

Reputation: 321

To filer columns use the "Column Filter" node. You can filter the columns specifically, by RegEx on the column name or by column type (int, double, etc.) To filter rows based on content, use the "Row Filter" node, and select column to test and "filter based on collection elements" using pattern matching. This can also use RegEx. For mulitple columns use multiple nodes.

Upvotes: 1

Charlesliam
Charlesliam

Reputation: 1313

Try to find specific value within the column of choice by using:

Select distinct(column_name) from table;

You can pick from the expected result to filter your data

Select * from table column_name like 'result_one';

Assuming the column_name data type is in character.

Upvotes: 1

Related Questions