SPLIT
SPLIT([Tags], ',')Syntax
SPLIT(text field, separator)
Text function which returns the array of text values by splitting text field with defined delimiter.
field: Any existed data field within income data set.
For example we have the data set below
| # | Names |
|---|---|
| 1 | Andrew, Mark, Ann |
| 2 | John, Alex |
| 3 | Adrian |
Applying SPLIT([Names], ',') will give the table below
| # | SPLIT([Names], ',') |
|---|---|
| 1 | Andrew |
| 1 | Mark |
| 1 | Ann |
| 2 | John |
| 2 | Alex |
| 3 | Adrian |