Summary

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

Configuration

Settings

Name

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

-


-

Want to learn more?

Examples

Example: Write result table into a TIS 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"



Troubleshooting

Nothing known up to now.


Related topics