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
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
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?
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
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.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.