---
title: Dynamic Custom Value
slug: segment/dynamic-custom-value
createdAt: 2026-01-15T19:49:50.825Z
---

Dynamic Custom Value (also known as the *CASE WHEN* statement in SQL) allows you to create a new field and populate different values depending on a set of conditions.

## Video overview

::embed[]{url="https://vimeo.com/685446299?fl=pl&fe=vl"}

## Create a Dynamic Custom Value

1. Under **Custom Values,** click the **Add new value** button.
2. Provide a name for the Custom Value, choose* Dynamic* as **Type**, and click **Next.**


::Image[]{src="https://support.deselect.com/hc/article_attachments/29471558252945" size="50" width="1306" height="1232" isUploading="false" darkWidth="1306" darkHeight="1232" showCaption="false"}

3. Select the type of value that you want to populate.
4. Click **Add Criteria **and create the condition that should meet the value you are going to populate.

::Image[]{src="https://support.deselect.com/hc/article_attachments/29471541821457" size="50" width="1310" height="578" isUploading="false" darkWidth="1310" darkHeight="578" showCaption="false"}

5. Under **THEN**, type in the value that you want to populate in case it fulfills the condition set above.

![](https://support.deselect.com/hc/article_attachments/29471558265489)

6. In case you need to add more criteria, click **Add Criteria** and repeat steps 4 and 5. Optionally, add a default value in case none of the criteria above were met. You can add it under the** Default** text box.
7. Click **Save** and move the new Custom Value to the Target Data Extension.

### Use an existing value

 If you need to show an existing value from a field as your value:

1. click on the **Pick available fields** icon.

::Image[]{src="https://support.deselect.com/hc/article_attachments/29471558268177" size="60" width="1204" height="266" isUploading="false" darkWidth="1204" darkHeight="266" showCaption="false"}

2. Choose the Data Extension and the field that you want to retrieve the value from.

::Image[]{src="https://support.deselect.com/hc/article_attachments/29471541834257" size="60" width="1232" height="250" isUploading="false" darkWidth="1232" darkHeight="250" showCaption="false"}

3. If you need to populate a NULL value, you can check the *NULL* checkbox below the free text field.

::Image[]{src="https://support.deselect.com/hc/article_attachments/29471541836177" size="60" width="1254" height="196" isUploading="false" darkWidth="1254" darkHeight="196" showCaption="false"}