You can specify more than one join condition when joining two data sets. For example, you can join a customers data set with a sales offices data set, shown in Figure 13-15, to find the names of customers and sales managers that are located in the same city and state.
Figure 13-15
The first condition, shown in Figure 13-16, compares the State values in the Customer and SalesOffices data sets and looks for a match.
Figure 13-16
The second condition, shown in Figure 13-17, compares the City values in both data sets and looks for a match.
Figure 13-17 The joined data set returns the results shown in Figure 13-18, if the join type is fullOuter.
Figure 13-18
|
|
Copyright Actuate Corporation 2012 |