Lookup Tables

Accessed through Lookup Tables. Lookup Tables are tables which store a set of values that can be used to perform mapping and transformations within Justransform. The tables of values can be used to look up specific values based on one or more keys.

For Example: A lookup table might be used to map country codes to country names, or to map product codes to product descriptions.

On the top of the Lookup Tables panel there are controls for:

  • Creating New Lookup Tables

  • Deleting a Lookup Table

  • Refresh

  • Uploading a Lookup Table

  • Downloading a Lookup Table

  • Updating a Lookup Table

  • Duplicating a Lookup Table

  • Truncating a Lookup Table

Information Panel

Clicking a table within the Lookup Tables panel, provides a Knowledge Panel providing table information, sharing details, and API access.

Adjust the Lookup Table Key/Value

Within the Information Panel, manage the lookup table values.

  1. Select the Lookup Table Key/Value to change. Click the Edit icon.

  1. Adjust the Key Name and/or Value

  2. Click the "✔️" check icon.

Delete the Lookup Table Key/Value

Within the Information panel, to delete a Lookup Table Key/Value.

  1. Select the Lookup Table Key/Value to delete. Click the Delete icon.

Share & Permissions

Within the Information Panel, share the lookup table with other users or groups.

  1. Click "Share Details"

  2. Click "+ Share"

  3. Select the user(s) to share the lookup table with (Enterprise User or Group).

  4. Click Select.

API Access

Within the Information panel, access API credentials for the lookup table. These can be used with the Justransform API. Selecting "API Access" opens the API Token panel.

Last updated