Create a Dynamic Lookup

Important Nexla Help Center Update:

Nexla's Zendesk Help Center pages are being deprecated and will soon no longer be available.

Nexla Documentation is now the home for Nexla's User Guides, with improved formatting and categories that are easier to navigate, providing a better overall user experience.

Please update any bookmarks to the new Nexla Documentation site (docs.nexla.com/user-guides).

_______________________________________________

This article provides information about creating a dynamic data lookup in Nexla. Data lookups can be used to convert data values based on information in another data source—data lookups manage relationships between data values. In a dynamic lookup, changes in these data relationships are automatically updated based on changes in the designated source—for example, a live data source such as an API.

For information about creating a static lookup, in which relationships between data values are managed manually, see our article Create a Static Lookup.

Contents:

1. Select a Nexset for Dynamic Lookup Creation
2. Send the Nexset to a Dynamic Lookup
3. Configure the Dynamic Lookup
4. Save and Create the Lookup

1. Select a Nexset for Dynamic Lookup Creation

1. Hover over on the toolbar on the left side of the screen, and select either My Nexsets or Shared with Me, depending on where the Nexset to be used to create the dynamic lookup is located.
   
   
   

   For information about how to connect to a data source that will produce Nexsets, see the articles in the Create a Data Source section.
   

2. Send the Nexset to a Dynamic Lookup

1. Click the icon on the destination to be used to create the dynamic lookup.
   
   
   
   
2. In the Destinations screen, select , and click in the top right corner of the screen. This will load the Configure Dynamic Lookup screen.
   
   

3. Configure the Dynamic Lookup

1. Enter a lookup name in the Name field.
   
   
   
   
2. Optional: Enter a description of the lookup in the Description field.
   
   
3. Set a key column as the primary key for the lookup using the Lookup Primary Key pulldown menu.
   
   
   
   
4. Optional: To set default values for the lookup keys, enter the desired default value to the right of each key name in the Default Values table.
   
   

4. Save and Create the Lookup

1. Once all required and desired optional lookup configurations have been set, click in the top right corner of the screen.
2. To activate the flow of data from the Nexset to the dynamic lookup, click .
   The flow can also be activated later, as described in Step 5 below, but the flow must be activated before the data in the source used for creation will be sent to your dynamic lookup. 
   
   
3. Click in the top right corner of the screen to close the Destination Configuration screen.
   
   
4. The dynamic lookup will now appear in the Lookups list accessed by hovering over on the menu on the left side of the screen and selecting on the menu that appears. 
   
   
   
   
5. Optional: To activate the flow at a later time:
   • Hover over and select from the menu that appears. 
     
     
   • Locate the flow used to create the dynamic lookup in the list, and click on the right side of the listing.
     
     
     
     
   • Select from the menu that appears to activate the flow. Data will now begin flowing from the source to the dynamic lookup.