Using Dynamic DeDuplicate Filters

This topic describes how to use dynamic DeDuplicate Filters.

1. Developers can make DeDuplicate Filter elements dynamic by using tokens:

As shown above, the Data Columns attribute value can accept tokens such as @Request, so that column names can bedynamic at runtime. Sometimes it is necessary to ensure that tokens have default values when running a report. When using @Request tokens, the Default Request Params element can be used to create default values for each @Request token.

2. The DeDuplicate Filter element also has an Include Condition attribute:

If the value of this attribute is left blank or contains a formula that evaluates to True, the element is applied to the datalayer. If the value evaluates to False, the element is ignored and does not affect the datalayer. This powerful feature allows developers to dynamically determine if the datalayer will be filtered or not.