DeleteDE

DeleteDE

This function deletes rows in a Data Extension that exactly match the specified column name and value pairs. No output results from the use of this function.

Arguments

DeleteDE(1,2,3,[4a,4b])

NOTE: Additional pairs of columns and values can be appended as arguments.

NOTE: This function only works in an email. Use DeleteData if you need to delete rows from a Data Extension in a landing page, microsite page or CloudPage, or in an SMS message in MobileConnect.

NOTE: According to the official order of processing, delete operations for the entire send are processed at the completion of the send. If your scripting utilizes a RaiseError function that aborts an entire send, the delete operation will not be completed.

Example 1

The following illustrates the use of this function with the minimum number of arguments.

Data Extension: LoyaltyMembers

The LoyaltyMembers Data Extension includes these rows:

Here is an example utilizing the preceding context:

%%[

var @lookupValue

set @lookupValue = AttributeValue("emailaddr") /* value from attribute or DE column in send context */
set @lookupValue = "suzy@limedash.com" /* or a literal value */

DeleteDE("LoyaltyMembers","EmailAddress", @lookupValue)

]%%

Output

After the operation, the LoyaltyMembers Data Extension includes these rows:

Example 2