Here is the 'Unnest' operation for string type transformation
Unnest
Unnest or create array or map columns to rows. When an array is passed to this function, it creates a new default column and it contains all array elements. When a map is passed, it creates two or more new columns one for key and one for value and each element in map split into the row.