Split string transform
Use this transform to split a string column into an array.
To add a Split String transform:
-
Navigate to your visual ETL job in Amazon SageMaker Unified Studio.
-
Choose the plus icon to open the Add nodes menu.
-
Under Transforms, choose Split String.
-
Select the diagram to add the node to your visual ETL job.
-
Connect the transform node to a data source node.
-
Select the node on the diagram to view details about the transform.
-
Under Column to split, select the column that you want to split.
-
Under Splitting regular expression, enter a regular expression that defines the separator token.
-
(Optional) Under Array column name, enter a name for the new column that contains the extracted array.