Defining Merge Criteria for New Columns

Define your merge criteria to map rows from the new columns with those from the standard table. From the columns retrieved by your saved search or RESTlet, choose one that matches the data of a column from the standard table. New rows that cannot be merged or have an empty value for the column also appear on the table.If a new row maps with multiple rows from the table, modify the criteria or add another one.

Depending on your table requirements, you may need to add multiple merge criteria with regard to the following cases:

If a new row maps with multiple rows from the table, you can modify the merge criteria or add another one.
If your saved search or RESTlet obtains columns from multiple records, add multiple criteria to map data from each record.

For example, if your saved search returns columns from both a transaction and an item record, choose a column from each to map to columns on the standard table.

To define merge criteria for new columns:

Access the merge criteria page for the type of process to which you want to add columns:
- For standard mobile processes, on the Mobile – Custom Column Setup page, click the Merge Criteria subtab, and then click New Mobile Configuration - Merge.
  
  For more information, see Adding Columns Through Mobile Configuration.
- For custom mobile processes, on the Mobile - Page Element page, click the Merge Criteria subtab, and then click New Mobile Customization - Merge Criteria.
  
  For more information, see Adding Columns Through Mobile Customization.
On the merge page, enter values in the following fields:
- Standard Column Key or Standard Column ID – Enter the response key associated with a column from the standard table.
  
  To view the list of response keys, click Show Standard Columns. From the popup window, you can copy the key that appears to the right of the colon.
- Configured Column Key or Custom Column ID – Enter the name of the new column from your saved search or RESTlet response.
  
  To display the list of response keys from a saved search, click Show Saved Search Columns. From the popup window, you can copy the key that appears to the left of the colon.
The new and existing columns that you want to map must contain the same type of data.

For example, you want to map the new rows with the existing rows using the purchase order ID. Set up the key associated with the purchase order ID column from the saved search or RESTlet and from the standard table.
Click Save.

Repeat the steps for each merge criteria you want to add.
To perform other customizations for your additional columns, see the following topics:
- Setting Up the On Load Action for New Columns
- Saving Data from Additional Columns
After you complete your customizations, make sure you apply the updates to the mobile app. For more information, see Compiling Mobile Customizations.

To define merge criteria for new columns:

Related Topics