Mapping Specification Guide

10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5

Back Next

Adding an Editing an Advanced Join

Add an advanced join to use expression functions in the join condition. Edit a simple join to modify the expression in the Expression editor.

From the Actions menu, click

Edit

Joins

The

Edit Mapping Specification

wizard appears.

On the

Join

panel, select one of the following choices:

To add a join, click the

New

icon.

To edit a join, select the join and click the

Edit

icon.

The

New Join

Edit Join

wizard appears.

Enter a name and an optional description.

Select a join type from the

Join Type

field.

Select a master data object from the

Master

field.

Select a detail data object from the

Detail

field.

Select

Advanced Join

On the

Functions

tab, select a function, click the

arrow

icon, select a column, and click

to add the function to the Expression editor.

Optionally, on the

Master Columns

tab, select a column and click the

arrow

icon to add it as a master column to the Expression editor.

Optionally, on the

Detail Columns

tab, select a column and click the

arrow

icon to add it as a detail column to the Expression editor.

Optionally, click the

Validate

icon to validate the expression.

Optionally, on the

Data Preview

panel, click the

Refresh

icon to preview the data.

Click

Mapping Specification Joins

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Mapping Specification Guide

Mapping Specification Guide

Adding an Editing an Advanced Join

Adding an Editing an Advanced Join