You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Iterate Row by Row and pass on the row value to Job
#1 2011-04-20 16:22:38
- gnyanendra
- Member
- Registered: 2010-11-15
- Posts: 11
Iterate Row by Row and pass on the row value to Job
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 cases where we are populating the tables for first times and have a data unprocessed for lets say last 2 years]
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 [to print the date values] 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 
Offline
#2 2011-04-20 16:30:22
- JohnGarrettMartin
- Member
- Registered: 2009-01-07
- Posts: 762
Re: Iterate Row by Row and pass on the row value to Job
try this way:
tMysqlInput--row1-->tFlowToIterate--iterate-->tJava
the column values will be put in the global map:
globalMap.get("row1.column_name");
Offline
#3 2011-04-20 16:36:49
- gnyanendra
- Member
- Registered: 2010-11-15
- Posts: 11
Re: Iterate Row by Row and pass on the row value to Job
Thank you so much John. It worked!
Offline
#4 2013-01-18 10:22:08
- Jai
- Guest
Re: Iterate Row by Row and pass on the row value to Job
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...
#5 2013-01-18 10:44:46
- xdshi
- Moderator
- Registered: 2012-08-27
- Posts: 1880
Re: Iterate Row by Row and pass on the row value to Job
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
What we can do is to make sure that Talend will be your best choice!
Offline
#6 2013-01-18 12:46:55
Re: Iterate Row by Row and pass on the row value to Job
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
do Svg your graphical language !!!
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Iterate Row by Row and pass on the row value to Job