Split and custom split options aren’t supported for sets, groups, parameters, and bins. New fields can’t be used as keys to join tables, but can be used to blend data sources. Things to keep in mind when working with splits and custom splits. For more information, see Additional Functions. In cases like this, consider using regular expressions to extract the desired information. For example, suppose a field includes the following values: Use regular expressions for fields contain mixed separatorsįields can’t be split automatically if the separator types are different. These return only a portion of the string based on a specified number of characters.įor example, if the value of a row is IGW8892: Calculationįor more information, see LEFT and RIGHT in String Functions. If your use case is more to extract a specific part of a string than to split it based on a separator, you can use the LEFT and RIGHT functions. Split manually using LEFT and RIGHT functions Department: SPLIT(, |, 2)įor more information, see the SPLIT function.The Employee Info example (such as "jsmith| accounting | north") would use three calculated fields: You define the separator and specify which value to return by providing a token number.įor example, to split Customer Name into First Name and Last Name, create two calculated fields: The SPLIT function works similarly to a custom split, but only one result field is returned per calculation. For the value without a region, the third result field will be null for that row. The custom split could be configured to split on the pipe character ("|") and split off all columns. Automatic split can't be used in these cases.įor example, suppose a field Employee Info has the following values: Note: In some cases, if the automatic split takes too long to generate new fields or Tableau can't find a common separator, the custom split dialog box displays.Ĭustom split is useful when the number of separators varies from value to value. The new fields generated by the custom split always result in a string data type. Select Custom Split.įrom the Data pane, in the Data pane, right-click the field you want to split, and then select Transform > Custom Split. On the Data Source page, in the grid, click the drop-down arrow next to the field name. You can specify the separator and choose to split the values at the first N occurrences of the separator, the last N occurrences, or at all occurrences. Use the custom split option for more control over the split. The data type of the new fields generated by the split can vary depending on the pattern combination that Tableau detects. The results of the split are standard calculated fields that can be edited or deleted like any other calculated field. In the Data pane, right-click the field you want to split, and then select Transform > Split. On the Data Source page, in the grid, click the drop-down arrow next to the field name, then select Split. You can also manually define the splitĭepending on the connection type, a split can automatically separate a field's values in up to ten new fields. Split fieldsĪ string field can be split automatically based on a common separator that Tableau detects in the field. See Alternatives to splitting from the menu. To split data while working in the browser, you can manually create a SPLIT calculation. Web authoring doesn't support splitting from a menu. On the Data Source page, check the menu for Split and Custom Split.įrom the Data pane on a sheet, check the menu for Transform > Split and Custom Split. You can tell if your data supports the SPLIT function by checking for the Split and Custom Split menu options: These are based on the SPLIT string function, which can also be used manually in a calculation for complete control over the split.
Tableau Desktop-but not web editing in the browser-has a menu option for automatic or custom splits. In the example of Customer Name, the common separator is a space (" ") between first and last name. You can use split options in Tableau Desktop to separate the values based on a separator (delimiter) or a repeated pattern of values present in each row. If you have string fields in your data that contain multiple distinct pieces of information (for example, the first and last name of a customer) you may be able to split the values into separate fields.