This Function will return a comma separated CSV string from a DriveWorks Table.
CSVFromTable([Data])
Where:
Data is the name of the table that a CSV string is created from.
Rule | Meaning |
|---|---|
| TableAverage(DwLookupStationaryOrder) | Creates a CSV string for the Lookup table with the name StationaryOrder |
Example StationaryOrder table (used in the example above).
| Item | Price | Quantity |
|---|---|---|
| HB Pencil | 0.60 | 3 |
| 2B Pencil | 0.60 | 2 |
| Black Biro | 0.80 | 1 |
| Rubber | 1.50 | 1 |
| HB Pencil | 0.60 | 2 |
| Black Biro | 0.80 | 1 |
The result given in the example, when viewed as a CSV file (in Notepad or similar), will look like:
Item,Price,Quantity HB Pencil,0.6,3 2B Pencil,0.6,2 Black Biro,0.8,1 Rubber,1.5,1 HB Pencil,0.6,2 Black Biro,0.8,1