In certain situations, duplicate sets of values may be returned from the database query, causing the output to be cluttered with unnecessary data. In this case, distinct results are desired.

After defining the fields in the Dynamic Template, click the Return Unique Results checkbox.

A simple use case might be a list of array types by product. The following example illustrates the results, before and after the Return Unique Results checkbox is checked.