{"id":31442,"date":"2018-04-21T15:47:46","date_gmt":"2018-04-21T15:47:46","guid":{"rendered":"https:\/\/ampscript.guide\/claimrowvalue\/"},"modified":"2021-08-06T12:30:49","modified_gmt":"2021-08-06T12:30:49","slug":"claimrowvalue","status":"publish","type":"post","link":"https:\/\/ampscript.guide\/claimrowvalue\/","title":{"rendered":"ClaimRowValue"},"content":{"rendered":"

ClaimRowValue<\/h2>\n

Like the ClaimRow<\/a> function, ClaimRowValue returns a single row from a Data Extension and reserves the values to prevent them from being used by another operation. If a row is found and is unclaimed, the designated claimed column is set to true<\/code> and data from that row is returned. Unlike ClaimRow<\/a>, if no unclaimed rows are available in the Data Extension, this function will return the value specified in the fourth parameter. Claimed rows can be used again if the designated claimed column changes back to false<\/code>.<\/p>\n

Generally speaking, you might choose to use the ClaimRowValue function over the ClaimRow<\/a> function when you have a default value that can be presented to your Subscribers.<\/p>\n

To utilize the ClaimRowValue function, you will need a Data Extension with some specific characteristics. At a minimum, your Data Extension must include the following:<\/p>\n

    \n
  1. a Boolean column that indicates claimed status, where true<\/code> is claimed and false<\/code> is unclaimed<\/li>\n
  2. a nullable column that represents the object or recipient claiming the row.<\/li>\n<\/ol>\n

    Arguments<\/h3>\n

    ClaimRowValue(1,2,3,4,5,6,[7a,7b]...)<\/code><\/p>\n\n\n\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 retrieve rows<\/td>\n<\/tr>\n
    2<\/td>\nString<\/td>\nTrue<\/td>\nName of the column from which to retrieve the value<\/td>\n<\/tr>\n
    3<\/td>\nBoolean<\/td>\nTrue<\/td>\nName of the column that identifies a row as claimed<\/td>\n<\/tr>\n
    4<\/td>\nString<\/td>\nFalse<\/td>\nDefault value to use if there are no available rows to claim<\/td>\n<\/tr>\n
    5<\/td>\nString<\/td>\nFalse<\/td>\nName of the Data Extension column to populate<\/td>\n<\/tr>\n
    6<\/td>\nString<\/td>\nFalse<\/td>\nValue of the Data Extension column to populate<\/td>\n<\/tr>\n
    7a<\/td>\nString<\/td>\nFalse<\/td>\nAdditional name of the Data Extension column to populate (see note)<\/td>\n<\/tr>\n
    7b<\/td>\nString<\/td>\nFalse<\/td>\nAdditional value of the Data Extension column to populate (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: The Data Extension name in the ClaimRowValue function cannot be an AMPscript variable.<\/p>\n

    NOTE: By default, this function does not support primary keys like the other update and upsert Data Extension functions. Additional name\/value pairs of arguments are only for recording additional information at the time the row is claimed, not for retrieving coupons using additional values. Marketing Cloud Support may be able to alter this default behavior by adding explicit indexes to your coupon data extension, per this documentation<\/a>.<\/p>\n<\/blockquote>\n

    \n\n\n\t\n\t
    \n\n\t\t\n\t\t