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.
Hi @B_Burgess ,
Have you tried, explicitly changing the datatype of the field to string in the data editor page of Quick Sight?
Hi @B_Burgess
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @B_Burgess
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!
Hi, sorry, I have been busy with other things and just returned to working on this. We are a very small business and so I wear a lot of hats. Hopefully you can reopen the topic.
@Yamini_Baskar_24 The data is already classified as a string in the editor. See screenshot.
