Create lookup data

Lookup is for data enrichment that is not directly available from incoming raw data. For example, it is used to identify region and market for the incoming network element. Typically, the raw data comes with information to lookup another lookup table to get the customer-specific data or view.

In this solution, where lookup can be directly created, everything about lookup table is kept dynamic so that extra tables can be created and modified at run time.

  1. Click the More actions () icon and select Lookup.
  2. Click the Create new (Create new button) button to open the Pack lookup page.
  3. Enter the look up name.

    For example, devices.

  4. Click Add/Edit header (Add or edit lookup fields icon) icon.
  5. Click the Add header (Add header icon) icon and enter the header name that you want to give in your lookup data in the Text field.
  6. Click OK.
    Similarly, you can create all the headers that are needed in the lookup. For example, you can create the following headers for the devices lookup:
    • Key

      It is the default header for which you must provide values. These values appear as rows in the For example, display name for the device.

    • DeviceName
    • DevicePort
    • DeviceUser
    • DevicePassword
    You can see the headers in the Pack lookup page.
  7. Click Add record to enter actual values for all the fields that are created.
  8. Click OK and click Commit.
  9. Provide comment in the Comment field and click Confirm.
  10. Click the Edit (Edit icon) icon for the lookup and edit the values for all the headers that are created previously.
  11. Click the Delete (Delete icon) icon to delete the lookup record.
  12. Click Commit and provide comment in the Comment field and click Confirm.

    You can see your lookup with its name, headers, and their values as specified by you.

  13. You can perform the following actions on your lookup records that are available in the Pack lookup page.
    • Click the Edit icon to add or edit the lookup headers and their values.
    • Click the Delete (Delete icon) icon to delete the lookup completely.
    • Click the Export (Export icon) icon to export the lookup to a JSON or an Excel format.
    • Click the Import icon and select Import and replace to import an available lookup and replace it with a specific lookup that is available on the Pack lookup page.

      Or, select Patch to append more lookup records from an external lookup to an existing lookup on the Pack lookup page.

    • Click the History (History icon) icon to view all the modifications that are made to a lookup in the table.

      From the History page, select any two revisions that you want to compare and click the Compare revisions (Compare revisions button) button.

      You can compare the changes that are done in both the revisions. You can also perform the following actions:
      Copy to clipboard
      Click the Copy to clipboard (Copy icon) icon to copy the contents of a revision.
      Export a revision content
      Click the Export (Export icon) icon to export the contents of the revision to a JSON file.

      You can see the file in your default Downloads folder with the name in this format:
      Lookup-<pack_name>-<lookup_name>-<timestamp>.

      For example: Lookup-telemetry-telemetry-devices-1677997818022.