New Column

The New Column analytic lets you add a column to the guide using a SQL expression. Using this feature requires both knowledge of SQL and knowledge of s-Server’s current contents (in that you will need to work with streams and tables in s-Server).

To add a new column:

  • Enter a name for the column.
  • Enter a SQL expression for the column.
  • Click the + icon to add the command to the Guide script.
  • The new column appears in the Output View window.