Altair SmartWorks Analytics

 

Splitting Columns

The Split operation is found within the Column Changes node; it allows you to separate the values in a field using a specific delimiter and then display the obtained “subvalues” as individual fields. This operation is only applicable to text fields. 

Prerequisites

  • An Execution Profile with an active session linked to the workflow

  • A Column Change node connected to a Data Frame node

  •  

Steps

  1. Configure the Column Changes node by double-clicking on the node or using the Open option provided in the node menu. 

  2. The table displays in the Node Viewer.

  3. In the Configuration tab, select the column including values you wish to split and then click Split > By Delimiter.

  4. Provide the delimiter the application should use as a basis to split values in the selected column.

  5. In the example below, the Desc field contains data on musical composers, one of their compositions, and, in some cases, the musician covering the composition. These data are separated by commas. Thus, we specify the comma as our delimiter.

     

  6. After SmartWorks Analytics splits the data in the field according to the delimiter you specified, it can display these subvalues in unique columns. Specify how many of these columns should be displayed in the Columns after split field. For example, if you expect two subvalues of “Pachelbel” and “Canon in D” in this order and wish to display both values, you should specify a value of 2. If you wish to display only the column containing the subvalue Pachelbel, specify a value of 1 instead. 

  7. Tick the box Position from the End of the String if the application should begin from the end (right-most side) of the field when deciding which split columns to display. If this box is ticked and, continuing with the example described in Step 4, we specify a Columns after split value of 1, the column returned will contain the subvalue Canon in D instead of Pachelbel. 

  8. Tick the box Keep Original Column to retain the original column when the table is updated with the split columns. 

  9. If you wish to apply the split operation to multiple columns, click on the Apply to multiple columns link and then choose which columns to apply the same operation to. Click Apply when you are done to save your selection(s).

  10. Select Apply when you are done.

  11. You can abandon the split operation by clicking the Cancel button instead. 

    Your table is updated as follows. To split the column Desc in the original table, we used the comma as a delimiter and a Columns after split value of 2. Using the comma as a delimiter yields three columns for values such as “Beethoven, Pathetique Sonata, Arau” and “Faure, 28 Songs, Stulzmann.” Because we instructed the application to return only 2 columns after the split operation, the third column (i.e., one that would include the values Arau and Stulzmann) does not display in the updated table. 

     

  12. To check the code that will be executed for your specified Column Changes configuration, save your specifications and then click on the Code tab of the Column Changes Node Viewer. You can also use the tab that displays to refine the code further. 

  13.  

  14. To complete the Column Changes node configuration, press Save. To cancel your changes and return to the Workflow Canvas, press Discard or simply close the Column Changes Node Viewer. To execute your column changes, click the Run button.