topic Re: Iterate Row by Row and pass on the row value to Job in Talend Studio

Iterate Row by Row and pass on the row value to Job

Anonymous — Sat, 16 Nov 2024 12:58:10 GMT

Hello,
I need to perform following job:
There is a job named Daily_ETL which populates certain MySQL tables on a daily basis, when the a date parameter is passed to it.
Now I want to make version 2 of this job which populates those tables for past dates
For that purpose, I have a table in database which lists all dates (from 2 years back to current date).
I want to read that table row by row and pass on the date value to my job which essentially has SQL queries. The date parameter shall be embedded in those queries.
I tried tMysqlInput ->tJava but all it prints is null.
I'll be greatly thankful if this gets resolved
I have attached snapshots of the job so as to correct me where I'm going wrong.
thanks.
PS- I'm new to forums

Re: Iterate Row by Row and pass on the row value to Job

Anonymous — Wed, 20 Apr 2011 15:30:22 GMT

try this way:
tMysqlInput--row1-->tFlowToIterate--iterate-->tJava
the column values will be put in the global map:
globalMap.get("row1.column_name");

Re: Iterate Row by Row and pass on the row value to Job

Anonymous — Wed, 20 Apr 2011 15:36:49 GMT

Thank you so much John. It worked!

Re: Iterate Row by Row and pass on the row value to Job

_AnonymousUser — Fri, 18 Jan 2013 09:22:08 GMT

Hi..

As you have worked on date , do you know how to work on time type...
Talend doesnt suppot only time data type I guess...
Please need a help regarding this...

Re: Iterate Row by Row and pass on the row value to Job

Anonymous — Fri, 18 Jan 2013 09:44:46 GMT

Hi jai,
All the Talend date method can be found in Talend code-->routine-->TalendDate where you can find all and globalMap.

Best regards
Sabrina

Re: Iterate Row by Row and pass on the row value to Job

Anonymous — Fri, 18 Jan 2013 11:46:55 GMT

hi,
you cannot write a flow in a tJava component (or using using iteration like JohnGarrettMartin suggestion).
It's the reason you 've got null value.
To flow data through tJava componenet, use tJavaRow.
regards
laurent