A dynamic lookup is helpful when the source table contains a large amount of data or it contains duplicate primary keys.
You can use dynamic lookup to help you classify your data based on these rules:
- DR_Range(x,y) - all matches from x to y
- DR_Pattern(*x*) - All matches before and after x (sensitive)
- DR_IPattern(*y*) - All matches before and after y case (insensitive)
- DR_All() - all results
Example 1:
.
Example 2: