You can use the Split Field feature in Quick BI to split a text field into multiple fields based on a separator. You can also use the Merge Fields feature to combine multiple text fields into a new field. This topic describes how to use these two features.
Prerequisites
You have created a dataset. For more information, see Create a dataset.
Limits
Only text fields are supported. You can merge a maximum of 10 fields.
Calculated fields are not supported.
Split a field
The Split Field feature splits a text field into multiple fields based on a separator. To configure the split, perform the following steps:
On the data processing page, click Split Field.
In the Split Field dialog box, select a field, set a Split Method, and then click OK.
View the result.
The new split fields are added to the dataset and can be displayed in dashboards, workbooks, data dashboards, and Downloads. For example, when used in a cross table on a dashboard, different split methods produce different results. The following examples show the results for different split methods:
Split the field into the First N columns.
The First N columns option splits the original field into N new fields. For example, if the Product Subcategory field contains "Scissors,Ruler,Saw", the separator is ",", and you choose to split the field into the First 3 columns.
This action creates three new fields. The result is shown below:
Split the field into the first N columns.
The Nth column option creates one new field that contains the value from the Nth position after the split. For example, if the Product Subcategory field contains "Scissors,Ruler,Saw", the separator is ",", and you choose to split the field into the 2nd column.
This action creates a new field with the value "Ruler". The result is shown below:
Merge fields
The Merge Fields feature combines multiple text fields into a new field using a connector. To configure this feature, perform the following steps:
On the data processing page, click Merge Fields.
In the Merge Fields dialog box, enter a Field Name, select the fields to merge, specify the Connector, and then click OK.
View the result.
The new merged field is added to the dataset and can be used in dashboards, workbooks, data dashboards, and Downloads. For example, if you drag the merged field to the Rows area of a cross table on a dashboard, the result is shown below:
