topic Re: How to retrieve values from tMySqlRow within a tIterateToFlow in Talend Studio

How to retrieve values from tMySqlRow within a tIterateToFlow

Anonymous — Sat, 16 Nov 2024 13:18:19 GMT

I need to be able to extract a list of id's from an XML file. Then run a SQL query into a DB and see if that id exists in the DB. Then I need to make a decision based on whether the id is in the DB or not.
Any recommendations on how best to do this?
I am running the following:
tFileInputMSXML -> tFlowToIterate ->tMySqlRow -> tIterateToFlow -> tLogRow
The SQL query in the tMySqlRow is :
"SELECT '1' as idExists FROM Sales WHERE id = '"
+((String)globalMap.get("XML.id"))+
"'"
My problem is that I don't see how to get access to the value of idExists.
I suppose it really is about understanding how to log output while inside a tIterate.
Anyone know how to get this done ?
glen
openbusinessassociates

Re: How to retrieve values from tMySqlRow within a tIterateToFlow

Anonymous — Thu, 26 Aug 2010 10:47:31 GMT

Hi,
instead of using
tFileInputMSXML -> tFlowToIterate ->tMySqlRow -> tIterateToFlow -> tLogRow
I would try to use
tFileInputMSXML -> tFlowToIterate ->tMySqlInput -> tLogRow

for the SELECT statement in tMySQLInput you can use the statement you pasted in your post.

HTH
Christian

Re: How to retrieve values from tMySqlRow within a tIterateToFlow

Anonymous — Thu, 26 Aug 2010 11:12:58 GMT

ACE. Works. Tks