Working with large datasets can be difficult, this tip shows you how to write an expression to create a sample set of data from your large dataset
For example: If you want to Browse, Map, Profile, etc. a 1 in 10 sample of your customer file use the following expression in the Where clause:
MASTER.GENERATED_KEY MOD 10 = 0
Taking a sample within a browse
· Open a browse with your customer data
· Right-click anywhere in the browse and click Add Column…
· On the expression builder navigate to the Filter ribbon
· Add in the expression below
MASTER.GENERATED_KEY MOD 10=0
The above image shows an unedited browse of customer data (5733 rows), whilst the below has been modified to show only one in ten of the customers (573 rows), allowing a more manageable yet representative sample
· This will filter your dataset to only select one in every ten, but could be done to filter a customer set by any amount (1 in 3, 1 in 5 etc)
