Page tree
Skip to end of metadata
Go to start of metadata

Summary

The results of a calculation are written in the TIS table.

 

Getting Started

This operator allows writing a TIS table into a defined folder within the TIS-Table structure with a defined table name. Both definitions are optional, so that  either the folder name or the table name only can be defined.
The definition of the folder and the table name are defined via a parameter and eventually within the [TIS]Board.

Define a parameter for your folder and/or your table name.

Go to General Parameter for Operations and create parameters with data type "Text". Define a value for each parameter.

Select or create a table which you want to write as a TIS table and choose the operation "Write TIS Table 3.0".

Choose here a predefined location within the TIS table structure or enter a folder manually. It can be a simple input of a name, the input for a parameter defined folder or a combination out of the two – like in the example.
The input Manual_TT\#XI.TISPar('Write Folder')# writes the TIS Table into a subfolder to the folder "Manual_TT" with the name which was defined in the parameters.
The checkbox below allows to create new folders. If not checked, TIS tables are only written into existing folders.
The table name can also be a simple name or a parameter definition – like in the example: #XI.TISPar('Write Table')#

Updating existing records

When you want to update an existing TIS Table, use one or more keys for the table. All existing data sets with a matching key will be updated.

Using Parameters

The path and or / table name can also be a simple name or a parameter definition – like in the example: #XI.TISPar('Write Table')#

 
Table updates only affect the current project clone.


For performance improvement, in case of multiple project clones of a template project using a shared TIS Table.

(warning) Note that you need to manually recalc the datanode reading from the TIS table, because it is potentially not set dirty due to this setting.

 

Want to learn more?

 Settings

The results of a calculation are written in the TIS table.

Parameter


ParameterValueOpt.DescriptionExample
Select Folder

System.String

opt.Name of the folder-
or enter folder

System.String

opt.Name of the folder, parameter possible. E.g.: Folder1\#XI.TISPar('Par1')#\Folder3-
Create folder if it does not exist

System.Boolean

-A new folder or the entire path will be created new if not already exists-
Table

System.String

-Name of the table which will be saved to.-
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 talbe (no action if table exists)
opt.Specifies how the data enters the TIS table.-
Key for updating

System.String

opt.Key which identifies the data sets which will be deleted and added again-
Create column RowId

System.Boolean

-Create column RowId-
Create column Time Changed

System.Boolean

-Create column Time Changed-
Create Time Created column

System.Boolean

-Create Time Created column-

 Troubleshooting

Nothing known yet.

 

Related topics

2 Comments

  1. 2 new options:

    • Delete rows with matching keys
    • Delete rows not matching keys

    FLEX-59 - Getting issue details... STATUS

  2. new option:

    • Create only new talbe (no action if table exists)

    FLEX-1496 - Getting issue details... STATUS