Data Base query

KNIME Analytics Platform
1

Hi there,

I know this is possible, but I have forgotten how you do this. In KNIME 2.0 how do I run a database query, where I pass a column variable into the executing SQL?

For example,

select round(to_number(to_date(’<##col1##>’, ‘yyyy-mm-dd HH24:MI:SS’) - to_date(’<##col2##>’, ‘yyyy-mm-dd HH24:MI:SS’))*24,1) from dual

Thanks in advance,

stanage

2

Hi stanage,
The Database Looping is your friend in this case.
Best, Thomas