The split action does not seem suitable when you don't know how many values separated by separator you have in one column. In this case you can't define your columns precisely. You can of course click many times on "Add more columns" but that's not convenient. What you want is just split and that's all. I don't think there's an action doing that easily.
It would be nice to have an option to split according the first data row and without naming columns, or a new split action doing this. You run it, it splits according to the first datarow and using "Column n" naming, that's all.
When the exact number of separators isn't known in advance, split the source column into rows, instead of columns, and then pivot. Before pivoting, you can add a step to calculate the desired column labels.
Let me be more clear. The goal of this feature request is that if I have such table :
Column 1
Column 2
Column 3
A
1
Paris;Tokyo
B
2
Mexico;London
I go to this, in one simple action, knowing that number of values in column 3 can change tomorrow :
Column 1
Column 2
Column 3
Column 4
A
1
Paris
Tokyo
B
2
Mexico
London
The name of new columns, it's not really a problem. The action split into columns does that, but you have to specify a fixed number of columns. It's not dynamic. There may be a simple way with an option "use first data row for columns", something like that.
