I have to split a cell into multiple columns, the split needs to be done based on position. All values in the cell need to be split into columns. I have tried the cell splitter node by position but you need to specify all col names and splits for it to work and the number of splits here will be more than 30. Is there a quicker way to do this?
Assuming this is what you want to do, it can be done with a java snippet. I’ve added a workflow here using different (but similar) options. The first is a java snippet that converts the column into a string of pipe-delimited characters, and then uses Cell Splitter on that.
The second is based on an even better (and less code) idea from:
which is to still use a java snippet but this returns the cell as a String Array column that can then be split using a Split Collection Column.