However I’m finding difficult to change a variable recognized by seektable as normal in his split version.
How can I force the system to split a variable?
SeekTable automatically detects CSV column as 'multi-value' if its unique rate (number of unique values after split / total number of values after split) is less than some threshold -- in this case you'll see an additional dimension "<column name> (Split)".
However, analyzer takes into account only first ~100 rows and in some cases a dimension for multi-value column is not proposed; in this case you can go to the cube configuration and add this dimension manually:
- Type: Field
- Name: "<csv_column_name> (Split)"