SplitColumn

Breaks one text column into several, splitting at a delimiter, the node version of Text to Columns. The original column is replaced by numbered text columns (Account_1, Account_2, ...), sized to the row with the most parts; rows with fewer parts leave the trailing columns blank. All other columns stay where they are.

Inputs

Input	Accepts	Required
`Table`	Table	Yes

Outputs

Output	Produces
`Result`	Table

Settings

Typed in on the node or set by the assistant, not wired.

Setting	Default	Notes
`Column`	—	Choose a column from the connected table. The text column to split (e.g. Account_Code).
`Delimiter`	—	The character(s) that separate the parts, such as `-`, `,`, or a space.

Example

Your GL_Detail table has an Account column coded 4000-EMEA-OPEX. Set Column to Account and Delimiter to -, and the result has Account_1 (natural account), Account_2 (region), and Account_3 (cost type), each now usable as its own grouping column. The split table appears as its own tab.

Tips

Follow with RenameColumns to turn Account_1,Account_2,Account_3 into Account,Region,Cost_Type.
The new columns are text, even when a part looks numeric.