SEPARATE
Action
¶
Bases: BaseMorphAction
Separate the string values in a single column into any number of new columns on a specified key.
Script template
"SEPARATE > ['destination_field_1', 'destination_field_2', etc. ] < 'by'::['source_field']"
Where 'by' can be any string with one MAJOR caveat. Since :: is used in the query, you cannot use
it for separating.
Example
"SEPARATE > ['new_1', 'new_2', 'new_3', 'new_4'] < ';;'::['separate_column']"
Will transform:
| ID | separate_column |
|---|---|
| 2 | Dogs;;Cats;;Fish |
| 3 | Cats;;Bats;;Hats;;Mats |
| 4 | Sharks;;Crabs |
Bitwise into each destination field. If more fields are required than are assigned, will raise an error.
| ID | separate_column | new_1 | new_2 | new_3 | new_4 |
|---|---|---|---|---|---|
| 2 | Dogs;;Cats;;Fish | Dogs | Cats | Fish | |
| 3 | Cats;;Bats;;Hats;;Mats | Cats | Bats | Hats | Mats |
| 4 | Sharks;;Crabs | Sharks | Crabs |
You will need a different strategy if separation results in more categories than you have destination fields for.