Spotfire Ideas Portal
This would be a unique class-leading feature.
Give us a new data transformation that would expand non-atomic data table cell values. Give us a wizard, like the Pivot transformation, to pull out individual values from a column whose cells containing a delimited list of values. Apply a table transformation like adding rows and columns, build a new table from the row key and the list of values (which become the new table's columns), perform an aggregation if needed, cherry-pick out individual values (if list contains name-value pairs), etc etc etc.
JP
Thanks for an excellent idea JP. This data format is getting more common. If you are able to share an example data set it would be valuable for our initital review of the idea. Please feel to reach out to me on tblomber@tibco.com. Thanks, Thomas