CSV: How to split a variable

4 views
Skip to first unread message

Q&A Bot

unread,
Mar 17, 2021, 7:43:08 AM3/17/21
to seektab...@googlegroups.com

Q:
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)"
Reply all
Reply to author
Forward
0 new messages