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:
1.Enter a name for the column.
2.Enter a SQL expression for the column.
3.Click the + icon to add the command to the Guide script.
4.The new column appears in the Output View window.