<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How to draw and use parameters on an iterate flow connection in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/How-to-draw-and-use-parameters-on-an-iterate-flow-connection/m-p/2211490#M9482</link>
    <description>I'm having a little trouble figuring out how to use tXXXRow components being fed from another query and / or parsed file.
&lt;BR /&gt;Lets say we have an tOracleInput component named "Input" which produces a result set with a string column called "PersonName". How do we use the "Name" result from each row in a query on the tOracleRow component?
&lt;BR /&gt;A concrete example would be greatly appreciated!
&lt;BR /&gt;Thanks</description>
    <pubDate>Wed, 01 Aug 2012 15:15:53 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2012-08-01T15:15:53Z</dc:date>
    <item>
      <title>How to draw and use parameters on an iterate flow connection</title>
      <link>https://community.qlik.com/t5/Talend-Studio/How-to-draw-and-use-parameters-on-an-iterate-flow-connection/m-p/2211490#M9482</link>
      <description>I'm having a little trouble figuring out how to use tXXXRow components being fed from another query and / or parsed file.
&lt;BR /&gt;Lets say we have an tOracleInput component named "Input" which produces a result set with a string column called "PersonName". How do we use the "Name" result from each row in a query on the tOracleRow component?
&lt;BR /&gt;A concrete example would be greatly appreciated!
&lt;BR /&gt;Thanks</description>
      <pubDate>Wed, 01 Aug 2012 15:15:53 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/How-to-draw-and-use-parameters-on-an-iterate-flow-connection/m-p/2211490#M9482</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2012-08-01T15:15:53Z</dc:date>
    </item>
    <item>
      <title>Re: How to draw and use parameters on an iterate flow connection</title>
      <link>https://community.qlik.com/t5/Talend-Studio/How-to-draw-and-use-parameters-on-an-iterate-flow-connection/m-p/2211491#M9483</link>
      <description>If your job is tOracleInput --row1--&amp;gt; tOracleRow, then create the SQL in tOracleRow like the following example (although you wouldn't use tOracleRow for a select statement generally).&lt;BR /&gt;"SELECT * FROM Customers WHERE PersonName="+row1.PersonName</description>
      <pubDate>Thu, 02 Aug 2012 02:08:16 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/How-to-draw-and-use-parameters-on-an-iterate-flow-connection/m-p/2211491#M9483</guid>
      <dc:creator>alevy</dc:creator>
      <dc:date>2012-08-02T02:08:16Z</dc:date>
    </item>
  </channel>
</rss>

