Anypoint Partner Manager (APM) enables you to create, populate and edit a lookup table. A lookup table is a table that facilitates transaction processing by associating values. For example, this page shows how to create a lookup table that associates home partner product codes with trading partner product codes.
|These settings are editable for the Home Partner (Your company in the Trading Partners Page) only.|
On the New Lookup Table Page in the Name box, type a descriptive name for the table you want to add.
The Save Button appears; click it to save the new table.
The Fields and Keys sections of the page appear, enabling you to add fields and keys.
To add a field, click Add field.
The Field Name box appears; enter a name for a field you want to add, then click Save (the checkmark icon) to the right of the box.
The new field name appears.
To add another field, repeat this step.
To add a key, click Add key.
The Key Name box appears.
In the Key Name box, enter a name for the key you want to add.
Click Add Field.
The Add Field selection box appears. Use the arrows to select a field you want make this key (or to make a part of this key), then click click the Plus symbol (+) next to new key.
To add more fields to this key, repeat the previous step until the key is what you want it to be.
|Lookup table settings are editable for the Home Partner (Your company in the Trading Partners Page) only.|
In the left-hand navigation pane, click Trading Partners. The Trading Partners Page appears.
In the Name table, click the name of the Home Partner.
The Company information page appears.
In the Partners section of the left-hand navigation pane on the Company information page, click Lookup Tables.
The Lookup Tables Page appears.
On the Lookup Tables Page, in the Lookup Tables dropdown listbox, click the down arrow.
The Lookup Tables dropdown list appears, populated with any lookup tables that have been created in the environment in which you are working.
To work with a table, click to select it from the dropdown list. The Lookup Tables Detail Page appears. The first row on this page is the Filter Row.
Until you add rows to a table, the Filter Row is the only row that appears. This is the case in Lookup Tables Detail Page.
Use the Filter Row to filter a column for a specific string. You can filter multiple columns at the same time; for example, if you type a in the first column and b in the second, the page displays all rows that include both an a in the first column and a b in the second.
To add a row to the table, see Add a Row to a Table.
To work with existing rows, see Working with Table Rows.
On the Lookup Tables Detail Page, click Add Row.
A new row appears under the Filter Row.
Enter values for the new row in the appropriate cells.
When you have entered all values, the Save icon at the right end of the new row (identified in Lookup Tables Detail Page, add row) is enabled.
Click the Save icon to save the new row..
The Lookup Tables Detail Page, row added appears.
To cancel the new row without saving, click the Cancel icon (identified in Lookup Tables Detail Page).
When multiple rows have been added to a lookup table, it appears as in Lookup Tables Detail Page, multiple rows added.
On Lookup Tables Detail Page, multiple rows added, click the Edit icon that corresponds to the row you want to edit. The Edit icon becomes a Save icon, and the Delete icon becomes a Cancel icon.
Edit or cells in the row as appropriate.
To cancel changes, click the Cancel icon.
To save changes, click the Save icon.
On Lookup Tables Detail Page, multiple rows added, click the Delete icon that corresponds to the row you want to delete.
The row you identified is deleted.