{"id":31448,"date":"2018-04-21T15:47:46","date_gmt":"2018-04-21T15:47:46","guid":{"rendered":"https:\/\/ampscript.guide\/deletede\/"},"modified":"2021-04-06T01:18:27","modified_gmt":"2021-04-06T01:18:27","slug":"deletede","status":"publish","type":"post","link":"https:\/\/ampscript.guide\/deletede\/","title":{"rendered":"DeleteDE"},"content":{"rendered":"

DeleteDE<\/h2>\n

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.<\/p>\n

Arguments<\/h3>\n

DeleteDE(1,2,3,[4a,4b])<\/code><\/p>\n\n\n\n\n\n\n\n\n\n
Ordinal<\/th>\nType<\/th>\nRequired<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\nString<\/td>\nTrue<\/td>\nData Extension from which to delete rows<\/td>\n<\/tr>\n
2<\/td>\nString<\/td>\nTrue<\/td>\nName of the column that identifies the row to delete<\/td>\n<\/tr>\n
3<\/td>\nString<\/td>\nTrue<\/td>\nValue that identifies the row to delete<\/td>\n<\/tr>\n
4a<\/td>\nString<\/td>\nFalse<\/td>\nAdditional column name that identifies the row to delete (see note)<\/td>\n<\/tr>\n
4b<\/td>\nString<\/td>\nFalse<\/td>\nAdditional value that identifies the row to delete (see note)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n

NOTE: Additional pairs of columns and values can be appended as arguments.<\/p>\n

NOTE: This function only works in an email. Use DeleteData<\/a> 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.<\/p>\n

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

Example 1<\/h3>\n

The following illustrates the use of this function with the minimum number of arguments.<\/p>\n

Data Extension<\/strong>: LoyaltyMembers<\/em><\/p>\n\n\n\n\n\n\n\n\n\n
Name<\/th>\nData Type<\/th>\nLength<\/th>\nPrimary Key<\/th>\nNullable<\/th>\nDefault Value<\/th>\n<\/tr>\n<\/thead>\n
EmailAddress<\/td>\nEmailAddress<\/td>\n254<\/td>\nN<\/td>\nN<\/td>\n<\/td>\n<\/tr>\n
SubscriberKey<\/td>\nText<\/td>\n254<\/td>\nY<\/td>\nN<\/td>\n<\/td>\n<\/tr>\n
FirstName<\/td>\nText<\/td>\n50<\/td>\nN<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
LastName<\/td>\nText<\/td>\n50<\/td>\nN<\/td>\nY<\/td>\n<\/td>\n<\/tr>\n
Created<\/td>\nDate<\/td>\n<\/td>\nN<\/td>\nY<\/td>\nCurrent Date<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The LoyaltyMembers<\/em> Data Extension includes these rows:<\/p>\n\n\n\n\n\n\n\n
EmailAddress<\/th>\nSubscriberKey<\/th>\nFirstName<\/th>\nLastName<\/th>\nCreated<\/th>\n<\/tr>\n<\/thead>\n
doug@limedash.com<\/td>\n8473<\/td>\nDoug<\/td>\nSmith<\/td>\n2017-10-21 12:01<\/td>\n<\/tr>\n
suzy@limedash.com<\/td>\n5497<\/td>\nSuzy<\/td>\nJackson<\/td>\n2017-10-20 11:01<\/td>\n<\/tr>\n
dale@limedash.com<\/td>\n7114<\/td>\nDale<\/td>\nCameron<\/td>\n2017-10-19 10:01<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Here is an example utilizing the preceding context:<\/p>\n

%%[\n\nvar @lookupValue\n\nset @lookupValue = AttributeValue(\"emailaddr\") \/* value from attribute or DE column in send context *\/\nset @lookupValue = \"suzy@limedash.com\" \/* or a literal value *\/\n\nDeleteDE(\"LoyaltyMembers\",\"EmailAddress\", @lookupValue)\n\n]%%<\/code><\/pre>\n
Output<\/h4>\n
After the operation, the LoyaltyMembers<\/em> Data Extension includes these rows:<\/p>\n\n\n\n\n\n\n
EmailAddress<\/th>\nSubscriberKey<\/th>\nFirstName<\/th>\nLastName<\/th>\nCreated<\/th>\n<\/tr>\n<\/thead>\n
doug@limedash.com<\/td>\n8473<\/td>\nDoug<\/td>\nSmith<\/td>\n2017-10-21 12:01<\/td>\n<\/tr>\n
dale@limedash.com<\/td>\n7114<\/td>\nDale<\/td>\nCameron<\/td>\n2017-10-19 10:01<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Example 2<\/h3>\n
\n\n\n\t\n\t
\n\n\t\t\n\t\t