Home Search

DriveWorks Pro 22
TableTranspose

Send Feedback

TableTranspose

Transposes (interchanges the columns and rows of) the given table.

Syntax

TableTranspose([Table])

Where:

Table is the table that is to be filtered.

Examples

Rule

Meaning
TableTranspose(DwLookupItems)

Inverts the example Items table (shown below) so the data in column 1 becomes the data in row 1, and the data in row 1 become data in column 1, resulting in:

{"Item","Single Drawer Unit","Double Drawer Unit","Single Cupboard Full","Double Cupboard Full","Single Cupboard with Drawer","Double Cupboard with Drawer","Cupboard Left Drawer Right","Cupboard Right Drawer Left","Single Cupboard with Drawer","Double Cupboard with Drawer","Cupboard Left Drawer Right","Cupboard Right Drawer Left";"Width","600","900","600","900","600","1200","1200","1200","600","1200","1200","1200";"Position","Rear Wall","Rear Wall","Rear Wall","Rear Wall","Left Wall","Left Wall","Left Wall","Left Wall","Right Wall","Right Wall","Right Wall","Right Wall";"Cost","330","495","280","440","300","600","610","610","300","600","610","610"}

Sample Data Table

Items Table

ItemWidthPositionCost
Single Drawer Unit600Rear Wall330
Double Drawer Unit900Rear Wall495
Single Cupboard Full600Rear Wall280
Double Cupboard Full900Rear Wall440
Single Cupboard with Drawer600Left Wall300
Double Cupboard with Drawer1200Left Wall600
Cupboard Left Drawer Right1200Left Wall610
Cupboard Right Drawer Left1200Left Wall610
Single Cupboard with Drawer600Right Wall300
Double Cupboard with Drawer1200Right Wall600
Cupboard Left Drawer Right1200Right Wall610
Cupboard Right Drawer Left1200Right Wall610


See also

How To: Work With Arrays