Data Manager Tips & Tricks: using 'LIKE' and wildcards in dataset filters
Hi: Recently, I was working with a very large data set where I only needed a small subset of the data it contained. One way to accomplish this rather easily is to use SQL LIKE and wildcards to include only data that matches the pattern you need. To do this, you must know the characters or values you want to include or exclude. In the Define Incoming Data set wizard, you can apply this code technique in the Filter tab. The syntax is: [Field Name] LIKE '%VALUE%' This will include only rows where t