33. Retaining a field value that does not need to be transformed in a Custom Value

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 delivery distribution in terms of continent, based on the delivery countries of your orders however, you want to make exceptions and retain the same values on some rows on your delivery country 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 orders to the selected data extensions section 2\ output hit the create data extension button, enter a name, eg deliveries per continent, and press save now we're going to add a custom value under custom values on the left, click add new value under name, enter continent and hit next choose type dynamic value for field type, choose text add the first category click on add criteria drag delivery country to the section on the right criteria equals value belgium click save under then, enter europe add the second category click on add criteria drag delivery country to the section on the right criteria equals value argentina click save under then, enter north america on the default field, click compare on the first field, choose deselect demo orders on the second field, choose delivery country hit save now, your custom value criteria should look like this we have now created an extra field in our target data extension that we want to populate with continent based categorization this field is not mapped to any fields in the source data extensions the logic defined above will, for each row, check the value of the delivery country of deselect demo orders , and output 'europe' if it equals to 'belgium', 'north america' if it equals to 'argentina' since the only values we want to populate continents are the ones listed above, all the other values that do not match the criteria will display the same value from the delivery country field of deselect demo orders select the following fields by dragging them to the section on the right id and delivery country from deselect demo orders continent from custom value click save data extension 3\ preview when you click run preview on the preview screen, a results table will be shown with fields id and delivery country from deselect demo orders continent, populated with europe , north america , and delivery country that does not need to be transformed