Select DAT

From TouchDesigner 088 Wiki

Summary

The Select DAT allows you to fetch a DAT from any other location in TouchDesigner, and to select any subset of rows and columns if it is a table.

PythonIcon.png selectDAT_Class

Parameters

DAT /dat - The path of the DAT being referenced.

Include First Row /firstrow - Forces the first row to be selected even if it is not specified by the Select Rows settings.

Include First Column /firstcol - Forces the first column to be selected even if it is not specified by the Select Cols settings.


Select Rows /extractrows - This parameter allows you to pick different ways of specifying the rows selected.

  • All - All rows selected.
  • by Name - Rows selected using Start Row Name and End Row Name parameters.
  • by Index - Rows selected using Start Row Index and End Row Index parameters.
  • by Start Name, End Index - Rows selected using Start Row Name and End Row Index parameters.
  • by Start Index, End Name - Rows selected using Start Row Index and End Row Name parameters.
  • by Values - Rows selected by specifying the row values explicitly.
  • by Condition - Rows selected by an expression to be evaluated for the from column.

Start Row Name /rownamestart - Specify the row name to start the selection range from.

Start Row Index /rowindexstart - Specify the row index to start the selection range from.

End Row Name /rownameend - Specify the row name to end the selection range.

End Row Index/rowindexend - Specify the row index to end the selection range.

Selected Row Values /rownames - Specify actual row names that you want to select. You can use pattern matching, for example row[1-4] will select all the rows names row1 thru row4.

Row Select Condition /rowexpr - Specify an expression that will be evaluated. If the expression evaluates to true, the row will be selected.

Expand the parameter and you will see that it is in expression mode.

SelectDAT rowselectexpr.png

By default, the Python expression is re.match('.*',me.inputCell.val) != None. '.*' means match any character multiple times, so this expression matches all values. If you want to match the parent's operator name followed by any numeric number you can use me.parent().name+'[0-9]*', where '[0-9]*' matches any numerical string. '.*'+parent().name+'.*' will match any cell that contains the operator's parent name. You can check Regular Expression Operations for additional information on how to use the Python Regular Expression module.

In Tscript, you can access the cell value with the local variable $V, and the row and column with $R and $C

From Column /fromcol - When selecting rows by values, this parameter selects which column to use when matching cell values to Selected Row Values to determine which rows are selected.


Select Cols /Select cols - This parameter allows you to pick different ways of specifying the columns selected.

  • All - All columns selected.
  • by Name - Columns selected using Start Col Name and End Col Name parameters.
  • by Index - Columns selected using Start Col Index and End Col Index parameters.
  • by Start Name, End Index - Columns selected using Start Col Name and End Col Index parameters.
  • by Start Index, End Name - Columns selected using Start Col Index and End Col Name parameters.
  • by Values - Columns selected by specifying the column values explicitly.
  • by Condition - Rows selected by an expression to be evaluated for the from row.

Start Col Name /colnamestart - Specify the column name to start the selection range from.

Start Col Index /colindexstart - Specify the column index to start the selection range from.

End Col Name /colnameend - Specify the column name to end the selection range.

End Col Index /colindexend - Specify the column index to end the selection range.

Selected Col Values /colnames - Specify actual column names that you want to select. You can use pattern matching, for example colvalue[1-4] will select all the columns named colvalue1 thru colvalue4.

Col Select Condition /colexpr - Specify an expression that will be evaluated. If the expression evaluates to true, the column will be selected. See Row Select Condition for more details.

From Row /fromrow - When extracting columns by Specified Names, this parameter selects which row to use when matching cell values to Selected Col Values to determine which columns are selected.


Output /output - Determines what format will be used for output from the DAT.

  • Input Data /data - Passes through data from first input without manipulation.
  • Strings /string - Evaluates input data as strings, including expanding any variable values to full strings.
  • Expressions /expr - Evaluates input data as expressions.

Variables

Local variables available are:.

  • $NR - number of input rows.
  • $NC - number of input columns.
  • $V - value of the cell, can be accessed when selecting by expression.
  • $R - current input row, can be accessed when selecting by expression.
  • $C - current input column, can be accessed when selecting by expression.