Performing Look Ups
In this section you will learn how to perform a Table Look up
Last updated
Was this helpful?
In this section you will learn how to perform a Table Look up
Last updated
Was this helpful?
Performing a lookup typically involves searching for a specific piece of information within a larger set of data or databases. In Osmos, once you have created your Dataset(s) and have added at least one Table, you are ready to perform a look-up.
A Lookup is created in the data transformation phase and is managed through a
Create a
Create a Table to hold the lookup data. At least two fields are required, the match field and the desired look-up field.
Note: A primary or foreign key on the Table is not required to leverage Lookups.
Upload the lookup data to the newly created Table
In the column mapping, map the Source field, match field, to the desired look-up Destination Column field. The match field is required in the source field to trigger the Datasets Lookup QuickFix
Once the column is mapped, go to QuickFixes, select Datasets Lookup.
Configure the Lookup:
Select the Dataset: Select the Dataset where the lookup field is located
Select the Table: Select the Table where the lookup field is located
Select the Lookup Field: Select the field you are looking up and wish to be populated in the destination column.
Select the Matcher Fields: Select the field you are matching between the source field and the mapping table. The field name will be the same as the Destination column name with the Lookup.
Hit Submit
The Destination column will be updated with the desired Looked-up field data.
