Hi all, I have a field in QS called priceitems of string datatype that can also take NULL’s. There are records that priceitems have values like [{“id”:27,“amount”:6.50,“explainer”:null,“quantity”:1.00000000,“quantityunit”:0,“total”:6.50,“billable”:false,“name”:“Catering”,“taxable”:false,“servicecos…

@Fotis_flex , In the dataset preparation mode, the parse json does work as @imaitri explained by using the dot notation. [image] calculation ifelse(isNull({jarry}),'no value found', parseJson({jarry},"$.0.name")) Kind regards, Koushik

How to extract key value from a .json array?

Q&A

Fotis_flex April 2, 2024, 9:34am 4

Hello @imaitri Do you perhaps have any more ideas regarding my above comment? Thx

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	1562	May 11, 2023
Parsing json and assoicating it to the row Q&A admin	9	89	December 11, 2024
parseJson() function referencing a JSON key with space Q&A error , calculations	5	1600	January 24, 2023
How to Parse JSON Column and Extract Specific convertedValue in Amazon Quick Sight Q&A dataset , calculations , Business-Intelligence-Engineer	3	69	September 19, 2025
What's parsejson syntax for parsing TA key value pair Q&A	3	316	May 11, 2023

How to extract key value from a .json array?

Related topics