<?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 Dynamically pass value tSampleRow in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Dynamically-pass-value-tSampleRow/m-p/2345883#M113342</link>
    <description>&lt;P&gt;I have a input file with 10 columns and a simple tmap which process the 10 columns and send it to tSampleRow where i hardcoded and to output file. It works fine.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Now i need to change the value of tSampleRow dynamically ( fetch value from database and set in context variable) and use the context variable in tSampleRow.&lt;/P&gt;
&lt;P&gt;Attached :&lt;/P&gt;
&lt;P&gt;1. Job&lt;/P&gt;
&lt;P&gt;2. ChildJob ( for loading context variable ) which works fine&lt;/P&gt;
&lt;P&gt;3. tRunJob&lt;/P&gt;
&lt;P&gt;4. tSampleRow&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Can you help me how to give the value in tSampleRow and What should i assign in tRunJob Context column.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Child Job works fine :&lt;/P&gt;
&lt;P&gt;System.out.println("hi");&lt;/P&gt;
&lt;P&gt;System.out.println(context.rows);&lt;/P&gt;
&lt;P&gt;globalMap.put("output",context.rows);&lt;/P&gt;
&lt;P&gt;System.out.println((String)globalMap.get("output"));&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Starting job DatabaseJob at 15:32 03/04/2018.&lt;/P&gt;
&lt;P&gt;[statistics] connecting to socket on port 3705&lt;BR /&gt;[statistics] connected&lt;BR /&gt;tContextLoad_4 set key "days" with value "monday"&lt;BR /&gt;tContextLoad_4 set key "rows" with value "5"&lt;BR /&gt;hi&lt;BR /&gt;5&lt;BR /&gt;5&lt;BR /&gt;[statistics] disconnected&lt;BR /&gt;Job DatabaseJob ended at 15:32 03/04/2018. [exit code=0]&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 08:28:17 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2024-11-16T08:28:17Z</dc:date>
    <item>
      <title>Dynamically pass value tSampleRow</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Dynamically-pass-value-tSampleRow/m-p/2345883#M113342</link>
      <description>&lt;P&gt;I have a input file with 10 columns and a simple tmap which process the 10 columns and send it to tSampleRow where i hardcoded and to output file. It works fine.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Now i need to change the value of tSampleRow dynamically ( fetch value from database and set in context variable) and use the context variable in tSampleRow.&lt;/P&gt;
&lt;P&gt;Attached :&lt;/P&gt;
&lt;P&gt;1. Job&lt;/P&gt;
&lt;P&gt;2. ChildJob ( for loading context variable ) which works fine&lt;/P&gt;
&lt;P&gt;3. tRunJob&lt;/P&gt;
&lt;P&gt;4. tSampleRow&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Can you help me how to give the value in tSampleRow and What should i assign in tRunJob Context column.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Child Job works fine :&lt;/P&gt;
&lt;P&gt;System.out.println("hi");&lt;/P&gt;
&lt;P&gt;System.out.println(context.rows);&lt;/P&gt;
&lt;P&gt;globalMap.put("output",context.rows);&lt;/P&gt;
&lt;P&gt;System.out.println((String)globalMap.get("output"));&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Starting job DatabaseJob at 15:32 03/04/2018.&lt;/P&gt;
&lt;P&gt;[statistics] connecting to socket on port 3705&lt;BR /&gt;[statistics] connected&lt;BR /&gt;tContextLoad_4 set key "days" with value "monday"&lt;BR /&gt;tContextLoad_4 set key "rows" with value "5"&lt;BR /&gt;hi&lt;BR /&gt;5&lt;BR /&gt;5&lt;BR /&gt;[statistics] disconnected&lt;BR /&gt;Job DatabaseJob ended at 15:32 03/04/2018. [exit code=0]&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 08:28:17 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Dynamically-pass-value-tSampleRow/m-p/2345883#M113342</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2024-11-16T08:28:17Z</dc:date>
    </item>
  </channel>
</rss>

