<?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 Execute Business Rules defined in a file using Variables in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Execute-Business-Rules-defined-in-a-file-using-Variables/m-p/2252890#M36392</link>
    <description>&lt;P&gt;Hello,&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;I would like to know if it's possible to define business/format rules (e.g FIELD == null ?0:1) within a file and execute them from Talend by defining variables.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Here's an example. I have this file (&lt;STRONG&gt;Campos_Reglas&lt;/STRONG&gt; in the Job) where I've defined the next rules for each column (PRODUCTO, COD_PROVEEDOR and NOMBRE_PROVEEDOR are the columns in the &lt;STRONG&gt;Input&lt;/STRONG&gt;&lt;span class="lia-unicode-emoji" title=":disappointed_face:"&gt;😞&lt;/span&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2019-07-25 17_25_09-Frit_Campos_Reglas.csv - Excel.png" style="width: 999px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6Fu.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/135787iFE2375C3D429863F/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M6Fu.png" alt="0683p000009M6Fu.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="okk.png" style="width: 999px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6Bj.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/155301i67B0F8FDF6E40539/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M6Bj.png" alt="0683p000009M6Bj.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;I've defined the fields as variables (&lt;STRONG&gt;tFlowTolerate&lt;/STRONG&gt;) and then I've created a tMap to call them:&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="a.png" style="width: 361px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6MX.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/144484i8783C4ABF10BA5FD/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M6MX.png" alt="0683p000009M6MX.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="aaaaaaaaa.png" style="width: 999px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6Ew.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/147683iC19F5FAA7F410F4A/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M6Ew.png" alt="0683p000009M6Ew.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;This is where I got stuck cause I don't know how to execute the rules (defined in my file) with just calling the variable.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Is there any expert who can solve this?&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Thank you!!&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 05:10:15 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2024-11-16T05:10:15Z</dc:date>
    <item>
      <title>Execute Business Rules defined in a file using Variables</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Execute-Business-Rules-defined-in-a-file-using-Variables/m-p/2252890#M36392</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;I would like to know if it's possible to define business/format rules (e.g FIELD == null ?0:1) within a file and execute them from Talend by defining variables.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Here's an example. I have this file (&lt;STRONG&gt;Campos_Reglas&lt;/STRONG&gt; in the Job) where I've defined the next rules for each column (PRODUCTO, COD_PROVEEDOR and NOMBRE_PROVEEDOR are the columns in the &lt;STRONG&gt;Input&lt;/STRONG&gt;&lt;span class="lia-unicode-emoji" title=":disappointed_face:"&gt;😞&lt;/span&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2019-07-25 17_25_09-Frit_Campos_Reglas.csv - Excel.png" style="width: 999px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6Fu.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/135787iFE2375C3D429863F/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M6Fu.png" alt="0683p000009M6Fu.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="okk.png" style="width: 999px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6Bj.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/155301i67B0F8FDF6E40539/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M6Bj.png" alt="0683p000009M6Bj.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;I've defined the fields as variables (&lt;STRONG&gt;tFlowTolerate&lt;/STRONG&gt;) and then I've created a tMap to call them:&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="a.png" style="width: 361px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6MX.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/144484i8783C4ABF10BA5FD/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M6MX.png" alt="0683p000009M6MX.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="aaaaaaaaa.png" style="width: 999px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6Ew.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/147683iC19F5FAA7F410F4A/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M6Ew.png" alt="0683p000009M6Ew.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;This is where I got stuck cause I don't know how to execute the rules (defined in my file) with just calling the variable.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Is there any expert who can solve this?&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Thank you!!&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 05:10:15 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Execute-Business-Rules-defined-in-a-file-using-Variables/m-p/2252890#M36392</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2024-11-16T05:10:15Z</dc:date>
    </item>
    <item>
      <title>Re: Execute Business Rules defined in a file using Variables</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Execute-Business-Rules-defined-in-a-file-using-Variables/m-p/2252891#M36393</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt; 
&lt;P&gt;You can achieve &lt;SPAN class="lia-message-read"&gt;ternary operator in tMap component. &lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-message-read"&gt;The expression should be:&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;PRE&gt;condition?value if true:value if false&lt;/PRE&gt; 
&lt;P&gt;&amp;nbsp;For more information, please have a look at this article about:&lt;/P&gt; 
&lt;P&gt;&lt;A title="https://community.talend.com/t5/Design-and-Development/tMap-expression-syntax/ta-p/21575" href="https://community.qlik.com/s/article/ka03p0000006EYeAAM" target="_self"&gt;https://community.talend.com/t5/Design-and-Development/tMap-expression-syntax/ta-p/21575&lt;/A&gt;&lt;/P&gt; 
&lt;P&gt;Best regards&lt;/P&gt; 
&lt;P&gt;Sabrina&lt;/P&gt;</description>
      <pubDate>Tue, 30 Jul 2019 08:05:00 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Execute-Business-Rules-defined-in-a-file-using-Variables/m-p/2252891#M36393</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2019-07-30T08:05:00Z</dc:date>
    </item>
  </channel>
</rss>

