32. Validate gender values for your customers

note the scenario below uses data from the deselect demo data package see docid 5 cozdtg0nwmlmeufrmbz scenario you want to make sure all gender values in your deselect demo customers data extension are valid acceptable values are 'm' and 'f' all other values should be replaced with the 'n/a' value note this scenario uses 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 customers to the selected data extensions section 2\ output hit the create data extension button, enter a name, eg customers with gender validation, and press save select the following fields by either double clicking on them or dragging them to the section on the right click on add all fields button in deselect demo customers data extension click save data extension now we're going to add a custom value under custom values on the left, click add new value under name, enter gender and hit next choose type dynamic value for field type, choose text add criteria click on add criteria drag gender to the section on the right criteria in value m,f click save next to then, click on the toggle icon select the deselect demo customers gender column from the available dropdowns fill in 'n/a' as the default value hit save click on the delete icon next to the gender field mapping and map it with the custom value we just created the logic defined above will, for each row, check the value of gender , and keep the original values if valid otherwise, it will replace the value with 'n/a' 3\ preview click on run preview button