Returns the number of rows in a data extension.
Availability
<table> <tr> <td>Marketing Cloud Engagement</td> <td>✅ Yes</td> </tr> <tr> <td>Marketing Cloud Next</td> <td>❌ No</td> </tr> </table>Syntax
DataExtensionRowCount(dataExtensionName)
The DataExtensionRowCount() has one parameter:
dataExtensionName(string): Required. The name of the data extension to find the row count of.
Usage
This example uses a data extension called "MembershipRewardsProgramme," which contains the data in this table.
| MemberId | FirstName | Surname | RewardsPoints | RewardsTier | Area |
|---|---|---|---|---|---|
| 1 | Dennis | Smithers | 92374 | 2 | Chelsea |
| 2 | Pooja | Chatterjee | 201042 | 1 | Hammersmith |
| 3 | Tomás | Santos | 69311 | 3 | Kensington |
| 4 | Sun-Hi | Kim | 23999 | 4 | Twickenham |
| 5 | Jian | Yeh | 15123 | 4 | Chelsea |
To use the function, pass it the name of the data extension.
%%[
Var @deRows
Set @deRows = DataExtensionRowCount("MembershipRewardsProgramme")
Output(v(@deRows))
]%%
The function returns the number of rows in the specified data extension, 5.