StateDMI / Command / DeleteTableColumns

Overview

The DeleteTableColumns deletes specified columns from a table.

The following dialog is used to edit the command and illustrates the syntax of the command. See also the full-size image.

DeleteTableColumns Command Editor

The command syntax is as follows:

DeleteTableColumns(Parameter="Value",...)

Command Parameters

Parameter	Description	Default
`TableID` required	The table identifier for the table to process. Can specify with `${Property}`.	None - must be specified.
`DeleteRowNumbers` required	The names of columns to delete, separated by commas. Can use `${Property}` to specify column names.	None - must be specified.

A simple comma-separated-value data as follows can be read with ReadTableFromDelimitedFile:

# Simple table for testing
"string1","double1","integer1"
"String1",1.0,1
"String2",2.0,2
"String3",3.0,3

The command file to read the above file and remove the first and last two columns is as follows:

ReadTableFromDelimitedFile(TableID="Table1",InputFile="testtable.csv")
DeleteTableColumns(TableID="Table1",DeleteColumns="double1,integer1")