Applies a format to all values in a specified column of a table.
TableFormat(Table or Table Name As Table, Column Index As Double, Format As String)
Where:
Table or Table Name is the Table to format.
Column Index is the number of the column in which the formatting will be applied.
Format is the formatting string to use. Where:
| Rule | Meaning |
|---|---|
| TableFormat(DWLookupCurrency,4,"MMM-YY") | Will return an array from the table Data, with the values in column 4 formatted as a date. See Example Outcome 1 below. |
| TableFormat(DWLookupCurrency,3,"0.0%") | Will return an array from the table Data, with the values in column 3 formatted as a percentage. See Example Outcome 2 below. |
Currency Table
| Country | Currency | Rate | Date |
|---|---|---|---|
| France | Euro | 1.3 | 29/03/15 |
| United States | Dollar | 1.4 | 18/02/15 |
| Germany | Euro | 1.3 | 22/01/15 |
| United Kingdom | Pound | 1 | 15/07/14 |
Currency Table
| Country | Currency | Rate | Date |
|---|---|---|---|
| France | Euro | 1.3 | Mar-15 |
| United States | Dollar | 1.4 | Feb-15 |
| Germany | Euro | 1.3 | Jan-15 |
| United Kingdom | Pound | 1 | Jul-14 |
DriveWorks will return the table above as an array, which will look like:
| Table returned as an Array |
|---|
| {"Country","Currency","Rate","Date";"France","Euro","1.3","Mar-15";"United States","Dollar","1.4","Feb-15";"Germany","Euro","1.3","Jan-15";"United Kingdom","Pound","1","Jul-14"} |
Currency Table
| Country | Currency | Rate | Date |
|---|---|---|---|
| France | Euro | 1.3% | 29/03/15 |
| United States | Dollar | 1.4% | 18/02/15 |
| Germany | Euro | 1.3% | 22/01/15 |
| United Kingdom | Pound | 1.0% | 15/07/14 |
DriveWorks will return the table above as an array, which will look like:
| Table returned as an Array |
|---|
| {"Country","Currency","Rate","Date";"France","Euro","1.3%","29/03/2015";"United States","Dollar","1.4%","18/02/2015";"Germany","Euro","1.3%","22/01/2015";"United Kingdom","Pound","1.0%","15/07/2014"} |