Get result of query as variable for each iteration

TJane1641356540 — Fri, 15 Nov 2024 23:07:35 GMT

I have a tdbinput which uses a select query like "select A,B,C from test"

I am trying to store the extracted values per each iteration from the database table into a context variable so i can use it later using tjava or tjavarow.

I tried using tsetglobalvar in the flow like:

TDBINPUT-main-->TSETGLOBALVAR---main--->TJAVAROW

iterate does not work above,it only accepts main row for each connection

But when i use context,it only retains the latest value,i would want for each

iteration

the results to get stored and processed?

My tjavarow has:

context.Atest=input_row.A;

What is the correct way to extract and store in context for each row in the database

Re: Get result of query as variable for each iteration

Anonymous — Sat, 12 Mar 2022 00:04:14 GMT

Use a tFlowToIterate component here. It will store each row's columns in the globalMap and iterate from that component. Everything that follows that component will fire completely for each row of data. The globalMap keys will be in the format....

{row name}.{column name}

So a String from "row1" with a column name of "myVal" will be retrieved like this....

((String)globalMap.get("row1.myVal"))

topic Get result of query as variable for each iteration in Talend Studio

Get result of query as variable for each iteration

Re: Get result of query as variable for each iteration