Join Lists

The JoinLists element provides a graphical representation of the 'joinlists' expression and creates a new list by joining together some existing lists. Other palette elements, for example, Rule Reference or Choose can be added to the empty member (fixedlist) of the JoinLists element. The JoinLists element can be added to other palette elements, for example, And Rule Group, Or Rule Group or When.

Properties:

The following table lists specific properties items for this element:

Table 1. Join Lists properties items
Name	Description
Single Item	Only one item returned from the element.
Behavior when no items found	Return either one of these results (error, return null) when no items found.
Behavior when multiple items found	Return either one of these results (error, return null, return first, return last) when multiple items found.

Pop-up menu:

The following table lists specific pop-up menu items for this element:

Table 2. Join Lists Pop-up Menus items
Name	Description
Remove Duplicates	Remove duplicate items in the Join Lists element.
Concatenate Results	Concatenate the items in the Join Lists element.
Join Inner Lists	Join the lists together to make one list.