How to create a Lookup Table for Data Tools?

Pramod Kumar Gudla-Support-Oracle

Summary:

This is about to create a lookup table for use in the Eloqua application. A lookup table is simply a list of two columns of values, for example, contact field values. The first column contains the values to be looked up, and second column contains values that will replace the original values

Content (required):

**This post was created as part of a How to Service Request (SR)

Version (include the version you are using, if applicable):

10

Code Snippet (add any code snippets that support your topic, if applicable):

Not Applicable

Pramod Kumar Gudla-Support-Oracle

Hello,

1. Navigate to Audience > Tools > Data Tools
2. Click the Data Tools menu > select New Lookup Table
3. Enter an appropriate display name, for example Normalize Country
4. Enter an appropriate description (optional).
5. Enter a lookup value column name
   • This is the column name for the original field values that you are looking up to replace, for example, Country
6. Enter a replacement value column name
   • This is the column name for the field values that will replace the original field values, for example, Normalized Country
7. Check or clear the Values are case-sensitive field, depending on the state of the data you are looking up
8. Click Save
9. Add values to the lookup table manually by entering the lookup value, the replacement value, and then click Add.
   • Multiple entries can be uploaded from an existing file by going to Manage Entries > Upload Lookup Table Entries
10. Click Save

Please note that this setting can only be changed when the table is empty.

Pramod Kumar Gudla-Support-Oracle

For more details, please review below documentation:

https://support.oracle.com/epmos/faces/DocumentDisplay?id=1631491.1