How to convert DB data to flowvariable.

KNIME Analytics Platform
#1

Hello.

I was wondering if there is a node can convert DB data to flow variable.
I’d appreciate it if you could tell me how.

Thanks,
hhkim

#2

Hi @hhkim , when you say DB data, do you mean an item of data that you’ve read from a database table?

If so, something like a DB Query Reader node to bring the row into a KNIME table followed by Table Row to Variable should do the job, or is there some other specific case that you are thinking of?

1 Like
#3

Thank you for your reply.

Yes, DB data is from database table.
And also, there is a specific case that I try to avoid using DB Query Reader node as much as possible.
So, is there any node can convert DB data to flow variable directly?

Thanks,
hhkim

#4

Hi @hhkim , it does not seem like you are reading @takbb 's question properly. The question is not just about DB data being from a database table, but also “an item of data”. And that is why he is also talking about “DB Query Reader node to bring the row into a KNIME table” as in one row.

If you DB data is a whole dataset (as in multiple rows), this could be a problem.

Could you elaborate what that case is and why you need to avoid using the DB Query Reader? There would not be a node that can convert DB data to flow variable directly, no.

1 Like