<?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>question LookupAttibute Example in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/LookupAttibute-Example/m-p/208633#M170590</link>
    <description>&lt;P&gt;I'm hoping someone can point me in the right direction. I have a SimpleKeyValueLookupService configured with some sample type I'm attempting to lookup. The way I understand it so far (from all the searches I've done) is in the LookUpAttribute I create a Dynamic Property of 'key' and set it's value to be in my case ${column_name}. So my question is where does the result get returned into?&lt;/P&gt;</description>
    <pubDate>Sat, 07 Oct 2017 01:33:15 GMT</pubDate>
    <dc:creator>hans_feldmann</dc:creator>
    <dc:date>2017-10-07T01:33:15Z</dc:date>
    <item>
      <title>LookupAttibute Example</title>
      <link>https://community.cloudera.com/t5/Support-Questions/LookupAttibute-Example/m-p/208633#M170590</link>
      <description>&lt;P&gt;I'm hoping someone can point me in the right direction. I have a SimpleKeyValueLookupService configured with some sample type I'm attempting to lookup. The way I understand it so far (from all the searches I've done) is in the LookUpAttribute I create a Dynamic Property of 'key' and set it's value to be in my case ${column_name}. So my question is where does the result get returned into?&lt;/P&gt;</description>
      <pubDate>Sat, 07 Oct 2017 01:33:15 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Support-Questions/LookupAttibute-Example/m-p/208633#M170590</guid>
      <dc:creator>hans_feldmann</dc:creator>
      <dc:date>2017-10-07T01:33:15Z</dc:date>
    </item>
    <item>
      <title>Re: LookupAttibute Example</title>
      <link>https://community.cloudera.com/t5/Support-Questions/LookupAttibute-Example/m-p/208634#M170591</link>
      <description>&lt;P&gt;&lt;A rel="user" href="https://community.cloudera.com/users/11952/hansfeldmann.html" nodeid="11952" target="_blank"&gt;@Hans Feldmann&lt;/A&gt;The best thing to explain this is to take an example. Let's say that you want to add an attribute city with a SimpleKVLookupService. And you will be doing the lookup by an attribute id_store (look &lt;A href="https://community.hortonworks.com/content/kbentry/138632/data-flow-enrichment-with-nifi-lookuprecord-proces.html" rel="nofollow noopener noreferrer" target="_blank"&gt;at this article&lt;/A&gt; to understand the logic behind this use case).
&lt;/P&gt;&lt;P&gt;You need to configure LookupAttribute as follows:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="39696-screen-shot-2017-10-07-at-93120-am.png" style="width: 1009px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/16855i8D4110C92F98EACC/image-size/medium?v=v2&amp;amp;px=400" role="button" title="39696-screen-shot-2017-10-07-at-93120-am.png" alt="39696-screen-shot-2017-10-07-at-93120-am.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;This means that the processor will use the value of the attribute id_store as a key and query the lookupservice. the returned value will be added as an attribute city. Here's the result:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="39697-screen-shot-2017-10-07-at-93414-am.png" style="width: 955px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/16856i5C600466A277F999/image-size/medium?v=v2&amp;amp;px=400" role="button" title="39697-screen-shot-2017-10-07-at-93414-am.png" alt="39697-screen-shot-2017-10-07-at-93414-am.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Of course, the flow file should have the attribute id_store before going in LookupAttribute.&lt;/P&gt;&lt;P&gt;And here's the content of the SimpleKVLookupService&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="39698-screen-shot-2017-10-07-at-93741-am.png" style="width: 1006px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/16857i7918DF697E1CB9F7/image-size/medium?v=v2&amp;amp;px=400" role="button" title="39698-screen-shot-2017-10-07-at-93741-am.png" alt="39698-screen-shot-2017-10-07-at-93741-am.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;I hope this helps&lt;/P&gt;</description>
      <pubDate>Sun, 18 Aug 2019 04:21:56 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Support-Questions/LookupAttibute-Example/m-p/208634#M170591</guid>
      <dc:creator>ahadjidj</dc:creator>
      <dc:date>2019-08-18T04:21:56Z</dc:date>
    </item>
  </channel>
</rss>

