I have a field in my dataset that stores values in an array, usually with just a single value, but most of the time either an empty array or null. I cannot seem to get Quicksight to work with this field, even when I try to treat it as a string. The field is listed as a string in the dataset editor so I’m not sure what’s going on.
Example data:
field name: {modification}
null
[“Held”]
[“Cancellation request”]
null
Desired output:
null
null
Held
Cancellation request
null
null
Even doing simple things like tostring({modification}) is giving me an incorrect type error, so I feel this is a data type issue. I have also tried messing with parseJson() but it’s really not formatted like a JSON with key:value pairs.
