Hey all! I have multiple columns with strings and one column with single level json string. Would it be possible to have {“example-metrics-service-base”:“7.0.0”,“example-service-rollout-hpa-base”:“7.0.0”,“example-service-rollout-spring-mvc-base”:“5.6.2”,“example-service-rollout-ingress-base”:“7.0…

Hi @quicksight-user001 - Looks like the issue is happening due to “-” in the column name. Is it possible to replace by underscore (“_”) and test it. Hi @WLS-DM - Looks like parseJson is not working if the column name contains _. can you please check whether we have any work around for the same or r…

Parsing json and assoicating it to the row

Q&A

Brett December 5, 2024, 9:14pm 2

Hi @quicksight-user001 and welcome to the Quick Sight community!

Take a look at the attached article below and let me know if this helps with your case.
Let us know if you have any additional questions!

1 Like

How to Parse JSON Column and Extract Specific convertedValue in Amazon Quick Sight

Topic		Replies	Views
parseJSON returns only the first json key value from an array Q&A data-source , calculations	5	1584	May 11, 2023
How to Parse JSON Column and Extract Specific convertedValue in Amazon Quick Sight Q&A dataset , calculations , Business-Intelligence-Engineer	3	102	September 19, 2025
What's parsejson syntax for parsing TA key value pair Q&A	3	316	May 11, 2023
parseJson() function referencing a JSON key with space Q&A error , calculations	5	1655	January 24, 2023
How to extract key value from a .json array? Q&A Business-Intelligence-Engineer	4	1060	April 2, 2024

Parsing json and assoicating it to the row

Related topics