Dataset1 has column FName and LName.
DataSet2 has FirstName,LastName and Region
We would like to Join FName--FirstName and LName--LastName and would like to display
FName,LName( from Dataset1) and Region from Dataset2, if values of columns match.
Here is syntax for Lookup Function.
LookupSet(source_expression, destination_expression, result_expression, dataset)
As we need to join on 2 columns from each Dataset. We need to concatenate the columns and then use in lookup.
Let's drag FName and LName from DataSet1 to Talix as shown and go to expressions for third column.
Our expressions will be like that
If you don't like to concatenate columns in expressions. You could have create FullName1 calculate field in both datasets by using below expressions
Right click on DataSet2--> Click Add Calculate Field and then write expression like shown below
Right Click on DataSet2 and go to Add Calculate Field and then Add FullName2 same way we did above. The expressions will be like below
Now you don't have to use concatenate the columns inside expressions for Lookup Function.
You can use calculate fields in Lookup Function to get the Region from DataSet2.
Step by Step Example explained in below Video