Write TIS Table 5.0

Summary

This operator creates or updates a TIS Table with the data and/or schema of the result table.

Select a folder and enter a name for the table.

Select "Replace entire table (incl. structure). This writes the result table into the TIS Table as-is. It overwrites an existing table.

The table name can be defined via a parameter. The parameter value can be set within TIS Board.

#XI.TISPar('TIS Table Name')# refers to the Parameter "TIS Table Name"

Settings

This operator creates or updates a TIS Table with the data and/or schema of the result table.

Parameter	Value	Opt.	Description	Example
Select Folder	System.String		Name of the folder	-
or enter folder	System.String		Name of the folder, can contain a parameter. E.g., Folder1\#XI.TISPar('Par1')#\Folder3	-
Create folder if it does not exist	System.Boolean	-	If checked, a folder or all folders on a new path will be created new if they do not exist	-
Table	System.String	-	Name of the TIS Table, can contain a parameter. E.g., #XI.TISPar('Par2')#	-
Paste mode	System.String Append only (key column is necessary) Update (key column is necessary) Replace entire table (incl. structure) Write table structure (deletes all data) Replace table content (keep structure) Delete rows with matching keys Delete rows not matching keys Create only new table (no action if table exists)	opt.	Specifies how the data enters the TIS Table. Defaults to "Replace table content".	-
Keys for updating	System.String	opt.	Set of key column names relevant for some of the "Paste mode" options	-
Create columns for Editable Grid	System.Boolean	-		-

Troubleshooting

Nothing known yet.