Returns a table based on an existing table with a new first column added with an incrementing number and a specified column heading
SppAddNumberColumn([Table Array],[Number Column Header Text],[IncludeLeadingZeros])
Where:
Table Array is a Table array (such as the data in a standard table, or the result of a QueryDataValues function).
Number Column Header Text is the text to use as the new heading.
IncludeLeadingZeros is set to TRUE to include leading zeros, FALSE to exclude.
| Rule | Result | Meaning |
|---|---|---|
| SppAddNumberColumn(DwLookupCustomers,"Reference",TRUE) | {"Reference","FirstName","SecondName";"1","John","Smith"} | Will return the table Customers with an additional column named Reference added to the start of the table. |