Creating a join allows you to validate a potential join as permanent.
To validate potential joins
- On the Home tab, select Joins > Create. The Create Join window opens.
- Review the LHS Entity drop-down list to select the entity that will become the left-hand side of the join.
- Use the RHS Entity drop-down menu to select the entity that will become the right-hand side of the join.
- (Optional) Click Filter to create a Filter expression for each entity involved in the join. Filters allow you to pick and choose which information to include in the join analysis. For information about creating expressions, see Using the Expression Builder.
- Click Next.
- Highlight an attribute from both the left-hand (LHS attribute) and right-hand (RHS attribute) sides and click Add Join.
- (Optional) To create a multiple attribute join, repeat Step 6.
- (Optional) If you add a join component that you do not want included, highlight it and click Remove Join.
- Click Next.
- Enter a Job Name.
- To create a join index, select the check box.
- Click Finish.
- Run the job now or schedule a time for the job to run later. If you run the job now, verify that the join analysis is complete by viewing background tasks.
-
Click Refresh and view the results by displaying all permanent (saved) joins.
Note: If you create a join and the total number of rows generated exceeds 2^32 (4294967296), some join metadata List Views may be unavailable.