Error if not Matched: Select to generate an error if the expression and string do not match to end the workflow processing.Column name for match status: Provide a name for the appended column.Match: Append a column containing a number: 1 if the expression matched, 0 if it did not.Size: Select data size to enter a new size.
Type: Use the dropdown to select the new data type.Name: Select column name to enter a new name.A new column is created in the Output Columns table with these columns: Parse: Separate the expression into new columns, and set the Name, Type, and Size of the new columns.Use a key column in your record so you don't lose track of which value came from which row. Split to Rows: Split a single column of data at each instance of the specified delimiter into multiple rows.The new columns are named as the root name with a serially increasing integer appended. Output Root Name: Enter the name that the newly generated columns should be based on.Error: Data the extends past the split causes an error and the workflow stops processing.Drop Extra without Warning: Data that extends past the split is dropped and no warning is generated.Drop Extra with Warning: Data that extends past the split is dropped and a warning is generated indicating that there was excess information.