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

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.


Last updated

Was this helpful?