Only show substring of the column?

I have imported a dataset and a column includes the following information in json format:
{“start”: “2024-01-01 00:00:00”, “end”: “2024-01-01 00:00:00”, “error”:“This is the error message”}
On the QuickSight table, instead of showing everything in json, I just want to show “error”:“This is the error message”. How can I do this?

1 Like

Hi @hojungkim - Welcome to AWS QuickSight community and thanks for posting the question. Can you please try to use parse json function to extract the require column value. Please see the documentation details below.

Regards - Sanjeeb

Thanks! I figured it out.

1 Like

Hi @hojungkim - Please mark the require message as solution so that it can help other community member.

Regards - Sanjeeb