Justransform
  • Getting started
    • Development/UAT
  • Navigation
  • EDI & B2B
    • EDI & B2B solutions
    • Trading Partners
  • Enterprise Integration Solution - Phases
    • The Platform
    • Defining Integrations
    • Testing & Validation
    • Deployment & Management
    • Onboarding Trading Partners
  • Dashboards
    • Accessing the Dashboards
  • Administration
    • User Management
    • Configuration - Form Mapping
  • Transactions
    • Console
      • Search Options and Filters
      • Results Table
  • Resources
  • Global Variables
  • Lookup Tables
  • Development
    • Connections
      • Creating a Connector
      • Updating a Connector
    • Business Processes
      • Creating a Business Process
      • Components of Business Process
        • Map/MapChain/JTScript (Custom Function)
        • Conditional Fork
          • IF Condition
        • (CBR) Content Based Routing
        • EDI to XML Transformation
        • XML to EDI Transformation
        • Insert Business Process
        • Import Business Process
        • Set File Name
        • Set Business IDs
        • Set Source Target Data Type
        • (STC) Set Target Connection
        • HL7EDI to XML Transformation
        • 997 Response Generation
        • CSV to XML Transformation
        • XML to CSV Transformation
        • IDOC to XML Transformation
        • PDF to XML Transformation
        • Flat File to XML transformation
      • JT UTILS
      • Updating a Business Process
      • Activating a Business Process
      • Opening/View a Previous Version of Business Process
        • View and Compare version history of Business Process
        • Open Previous Version of Business Process
    • Mapper & Map Chains
      • Mapper
        • Creating a Map
        • Updating a Map
      • Map Chains
        • Creating a Map Chain
        • Updating a Map Chain
        • Running a Map Chain
    • Scripts
      • Creating a Script
      • Updating a Script
    • FF Operations
    • Hex Editor
  • Testing
    • Test Manager
      • Creating a Test Case
      • Managing a Test Case
  • Productivity
    • EDI
      • EDI Specifications
      • EDI Operations
    • B2B Office Suite
      • Sheets
      • Workflow Editor
      • Documents
      • Forms
      • CSV Validation
      • PDF Extractor & PDF
      • Diagrams
    • Programs
  • API
    • Documentation
  • Support
    • Creating a Support Request
    • Managing Support Tickets
Powered by GitBook
On this page
  • Information Panel
  • Adjust the Lookup Table Key/Value
  • Delete the Lookup Table Key/Value
  • Share & Permissions
  • API Access

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.

PreviousGlobal VariablesNextConnections

Last updated 2 years ago