Exploding fields

Data in one column can be split to separate essential information into individual fields.

Delimited Text

You might have critical data stored in a single column, separated by a delimiter. To apply transformations to this data, you need to segregate the values into different rows. In Algoreus, you can split fields in a column into separate rows based on a delimiter. The following delimiters can be used to split values:

• Comma

• Tab

• Pipe

• Whitespace

• Custom separator

Note: If you choose Custom separator, you must use a regular expression (regex) to define the separator. Regular expressions allow the usage of intricate search patterns when breaking down the data in the column. Standard Java regular expression constructs are supported.

If the value does not contain the specified separator, no additional rows are created.

To split values based on a delimiter, follow these steps:

1. From the drop-down menu, click Explode > Delimited text.

2. Choose the delimiter to use for splitting the fields.

Algoreus divides the fields based on the chosen delimiter and adds the split-to-row directive to the recipe. When you run the data axon, the transformation is applied to all column values.

---