Iterate of MySQL Query results

One Star

Iterate of MySQL Query results

I need to create a separate RSS file for each row in a MySQL database using TOS 3.0.3 and Java.
A straight through tMySQLInput -> tMap -> tRSSOutput generates a single RSS file with each row as an article. I know I need to iterate at some point, but am unsure where or how to do it.
I have redone the job so that two SQL queries are done. The first to retrieve a list of IDs and a second to retrieve the row(s) for each ID.
When tracing the job, a row appears for row1, but nothing appears for row2, row3 or RSS.
I am getting a RSS file written for each ID, but it is using context variables that I am setting in the top tJavaRow component and not the row data form the second tMySQLInput component.
Is there some magic that I am missing to iterate of SQL data, do a second query off of it and work with the results?
Please advise,
Robert
One Star

Re: Iterate of MySQL Query results

Hi Robert,
if you need one file for each row take a look at 22999
Bye
Volker
One Star

Re: Iterate of MySQL Query results

Thanks for the pointer.
I found the following link referenced in the article:
http://www.talendforge.org/forum/viewtopic.php?id=5827
Thanks,
Robert

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch