Sample Guide Process
Let's say you start with a simple log file with a stock ticker feed with date, close, volume, open, high, and low:
The log file initially appears in the Output view with two columns, one for rowtime and one column called MESSAGE that contains all the values separated by commas:
Your first step here is to separate out the values. Begin by selecting the MESSAGE column. When you do, StreamLab offers you several suggestions in the Suggestions list:
At this point you can simply click the + to the right of the first suggestion, "Split column MESSAGE using the automatic pattern Comma-Separated Values (CSV)".
You can also select the Basic:Split command to view more information on the splitting operation.
Note that the Split command has MESSAGE preselected for the column. That is because you have selected MESSAGE in the Output view. Also note that the options Auto and Comma-Separated Values (CSV) have been preselected. That is because these are the most likely selections for the column.
Click the + sign to the right of the Split...CSV suggestion. The Message column splits into six separate columns.
Next, you want to rename the new columns to date,close,volume,open,high,low. You can do so using the Basic:Rename List command. First, select columns MESSAGE_1 through MESSAGE _6. If it is not already selected, select Basic from the Commands popup menu, then select the Rename List tab.
Next, enter the following into the To List field:
Click the + sign to the right of the Rename Columns... suggestion. The columns are renamed:
Next, cast the columns Close, Volume, and Open as column type DOUBLE. You can do so using the Basic:Cast command. First, select columns Close, Volume and Open. Next, select the CAST command and select DOUBLE from type. Note that the three columns appear in the Columns field. Click the + sign to the right of the Cast Columns... suggestion. The columns are cast as DOUBLE.
Next, you can create a new column with a running average for close. To do so, select the column Close and choose the Analytics:Running Average command.
Click the + sign to the right of the Add column named... suggestion. A new column called Avg appears: