Edit Table Columns dialog
The Edit Table Columns dialog defines the structure of the data table to output from a SQL Execute or R Execute operator.
SQL and R are dynamic languages that can generate arbitrary output at runtime. Because many big-data technologies are static (that is, the types are known in advance), TIBCO Data Science – Team Studio must validate that the values specified in this dialog are the values SQL or R returns at runtime. This design ensures that in case of a mismatch, TIBCO Data Science – Team Studio can notify the user and advise them how to correct the problem.
When you first add a SQL Execute or R Execute operator and view the Result Table Structure, you see that it is empty. This result is expected because the SQL or R script has not run yet, and TIBCO Data Science – Team Studio does not yet know what column names should be in the output. After running the operator once, you can see that the column names from the alpine_output variable are populated. To add more columns to your output, you must ensure that they are present in the script as well as in the Result Table Structure columns.
To use the Edit Table Columns dialog, provide the following.
| Name | Description |
|---|---|
| Column Name | For each column, specify a valid column name. |
| Column Type | For each column, specify the data type for the associated Column Name. |
| New Field | Click add a new table column to the structure. |
| Delete | Click to delete the column. |
| Down | Adjust the position of the column downwards. |
| Up | Adjust the position of the column upwards. |