How can I automatically split column headers and names?

Data imported to Parabola may come in a format where multiple pieces of data are expressed in a single column. In this case, it can be helpful to split out one column into many, including the names of the columns, not just the data within the column.

If you need to split an existing column into more columns in a consistent, automated fashion, use the Split columns step. This step can split a column, based on a delimiter, into any number of additional columns.

If the data entering the step is consistent, then you can use the Edit columns step to rename headers after using the Split columns step.

If you need to split a column’s name into more columns dynamically, i.e. the data is not always delivered in a consistent format, use the Custom transform step. Within that step, give clear instructions for how to perform the split.