Demo Data Package
Demo Data Package Scenarios
22. Add a dynamic value to your results
note the scenario below uses data from the deselect demo data package see docid 5 cozdtg0nwmlmeufrmbz scenario you want to add a new field to your target data extension that indicates a categorization of the size of a company (account), based on the number of employees note this scenario uses the feature custom values, which is available in deselect plus and advanced 1\ input on the selections overview screen, click on new to create a new selection drag data extension deselect demo accounts to the selected data extensions section 2\ output hit the create data extension button, enter a name, eg accounts with size, and press save select the following fields by either double clicking on them or dragging them to the section on the right company name and number of employees from deselect demo accounts drag company name again, and rename it to size click save data extension click on the delete icon next to the company name field that's mapped to size we have now created an extra field in our target data extension that we want to populate with our size categories this field is not mapped to any fields in the source data extensions now we're going to add a custom value under custom values on the left, click add new value under name, enter size and hit next choose type dynamic value for field type, choose text add first category click on add criteria drag number of employees to the section on the right criteria smaller than or equal to value 10 click save under then, enter startup add second category click on add criteria drag number of employees to the section on the right criteria between value 11 and 49 click save under then, enter small add third category click on add criteria drag number of employees to the section on the right criteria between value 50 and 249 click save under then, enter medium add last category click on add criteria drag number of employees to the section on the right criteria greater than value 250 click save under then, enter large hit save the logic defined above will, for each row, check the value of number of employees, and output 'startup' if it's lower than or equal to 10, 'small' if it's between 11 and 49, 'medium' if it's between 50 and 249, and 'large' if it's greater than 250 now that the custom value size has been created, we can map it to field size by drag and dropping it from custom values to the size mapping field 3\ preview when you click run preview on the preview screen, a results table will be shown with fields company name and number of employees from deselect demo accounts size, populated with startup , small , medium or large