UpdateDE
Overview
Updates an existing row in a data extension for the specified number of columns used to build the where clause listed in name value pairs followed by a list of columns to be updated in name value pairs. Returns no value. Use this function with email messages at send time only.Syntax
UpdateDE(1, 2, 3, 4, 5, 6)
| Ordinal | Type | Description | |
|---|---|---|---|
| 1 | string | Required | Name of data extension from which to update the specified row |
| 2 | numeric | Required | Number of columns used to build WHERE clause |
| 3 | string | Required | Column name to build WHERE clause |
| 4 | string | Required | Value used to build WHERE clause |
| 5 | string | Required | Column name to build INSERT clause |
| 6 | string | Required | Value used to build INSERT clause |
Usage
UpdateDE('SendDE',1,'_SubscriberKey',_SubscriberKey,'DateSent',NOW())