How to convert DB data to flowvariable.

[hhkim]

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

[takbb]

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?

[hhkim]

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

[bruno29a]

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.

@hhkim

there is a specific case that I try to avoid using DB Query Reader node as much as possible

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.