<?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 [resolved] tFilterRow Advanced Mode : How to filter a list in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/resolved-tFilterRow-Advanced-Mode-How-to-filter-a-list/m-p/2313872#M84687</link>
    <description>Hi&amp;nbsp; My job selects in input a list of users in Active Directory and filters the users based on the AD group they belong to. (see image) 
&lt;BR /&gt;The AD group attribute is a list. 
&lt;BR /&gt;I tried the advanced mode of the tFilterRow with this condition : 
&lt;FONT color="black"&gt;&lt;FONT size="2"&gt;&lt;FONT face="Tahoma"&gt; &lt;B&gt;input_row.memberOf.contains(&lt;/B&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt; 
&lt;B&gt;&lt;FONT color="#2a00ff"&gt;&lt;FONT size="2"&gt;&lt;FONT face="Tahoma"&gt;"GU_GIE_A_ISE0_WIFI_SIE"&lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/B&gt; 
&lt;FONT color="black"&gt;&lt;FONT size="2"&gt;&lt;FONT face="Tahoma"&gt;&lt;B&gt;)&lt;/B&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt; 
&lt;BR /&gt; 
&lt;FONT color="black"&gt;&lt;FONT size="2"&gt;&lt;FONT face="Tahoma"&gt;but it does not work&amp;nbsp; (0 user in output of the filter)&amp;nbsp;&amp;nbsp; &lt;BR /&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt; 
&lt;BR /&gt; 
&lt;FONT color="black"&gt;&lt;FONT size="2"&gt;&lt;FONT face="Tahoma"&gt;This is for example what I get from the AD for one user:&lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt; 
&lt;BR /&gt;John|WOO|ESH0009|john.woo@test.fr|94100-00001/00873/00877/00900//00962|Lattes| 
&lt;BR /&gt;Do you know how to use 'contains' with a list ? 
&lt;BR /&gt; 
&lt;IMG src="https://community.talend.com/legacyfs/online/membersTempo/366474/tFilter.png_20160719-0731.png" /&gt;</description>
    <pubDate>Tue, 19 Jul 2016 15:30:42 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2016-07-19T15:30:42Z</dc:date>
    <item>
      <title>[resolved] tFilterRow Advanced Mode : How to filter a list</title>
      <link>https://community.qlik.com/t5/Talend-Studio/resolved-tFilterRow-Advanced-Mode-How-to-filter-a-list/m-p/2313872#M84687</link>
      <description>Hi&amp;nbsp; My job selects in input a list of users in Active Directory and filters the users based on the AD group they belong to. (see image) 
&lt;BR /&gt;The AD group attribute is a list. 
&lt;BR /&gt;I tried the advanced mode of the tFilterRow with this condition : 
&lt;FONT color="black"&gt;&lt;FONT size="2"&gt;&lt;FONT face="Tahoma"&gt; &lt;B&gt;input_row.memberOf.contains(&lt;/B&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt; 
&lt;B&gt;&lt;FONT color="#2a00ff"&gt;&lt;FONT size="2"&gt;&lt;FONT face="Tahoma"&gt;"GU_GIE_A_ISE0_WIFI_SIE"&lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/B&gt; 
&lt;FONT color="black"&gt;&lt;FONT size="2"&gt;&lt;FONT face="Tahoma"&gt;&lt;B&gt;)&lt;/B&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt; 
&lt;BR /&gt; 
&lt;FONT color="black"&gt;&lt;FONT size="2"&gt;&lt;FONT face="Tahoma"&gt;but it does not work&amp;nbsp; (0 user in output of the filter)&amp;nbsp;&amp;nbsp; &lt;BR /&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt; 
&lt;BR /&gt; 
&lt;FONT color="black"&gt;&lt;FONT size="2"&gt;&lt;FONT face="Tahoma"&gt;This is for example what I get from the AD for one user:&lt;/FONT&gt;&lt;/FONT&gt;&lt;/FONT&gt; 
&lt;BR /&gt;John|WOO|ESH0009|john.woo@test.fr|94100-00001/00873/00877/00900//00962|Lattes| 
&lt;BR /&gt;Do you know how to use 'contains' with a list ? 
&lt;BR /&gt; 
&lt;IMG src="https://community.talend.com/legacyfs/online/membersTempo/366474/tFilter.png_20160719-0731.png" /&gt;</description>
      <pubDate>Tue, 19 Jul 2016 15:30:42 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/resolved-tFilterRow-Advanced-Mode-How-to-filter-a-list/m-p/2313872#M84687</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-07-19T15:30:42Z</dc:date>
    </item>
    <item>
      <title>Re: [resolved] tFilterRow Advanced Mode : How to filter a list</title>
      <link>https://community.qlik.com/t5/Talend-Studio/resolved-tFilterRow-Advanced-Mode-How-to-filter-a-list/m-p/2313873#M84688</link>
      <description>I fixed it&amp;nbsp; It works if I entrer in the filter the whole value of the attribut memberOf, ie: CN=GU_GIE_H_UNI_00962_MEMBRE,OU=Groupes,OU=MyOU,DC=Test</description>
      <pubDate>Wed, 20 Jul 2016 10:23:49 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/resolved-tFilterRow-Advanced-Mode-How-to-filter-a-list/m-p/2313873#M84688</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-07-20T10:23:49Z</dc:date>
    </item>
  </channel>
</rss>

