Spotfire Ideas Portal
I have a column with multiple values inside, with a separator between each value. The number of values is not the same on every row.
If I use the standard split column feature, I will generate a number of columns corresponding to my max number of values in the column.
If I then unpivot, I need to choose every column I want to unpivot and this may vary if i update the dataset with a dataset containing more values in the column.
I would like to be able to directly split a column into rows without having to use a data function
I agree with Kelsey's comment. It would be very helpful to have the split functionality automatically detect (or you could feed it with a calculated value) the max number of splits you need, based on the max number of times the "split by" character appears in a column value.
I would like to add to this idea. I don't mind using the unpivot, but I would like the split functionality to be automatically applied eat time the data is loaded. Right now, when you do it manually, let's say you have at most 4 splits. In time, when the data comes in with 5 splits, you still only have your 4 columns. I would like it to auto-create the columns based on the max split each time, so the unpivot always includes all distinct separate values.