Expose JSON Key in a widget

Question

Hi All,I am trying to understand if there is any way to extract json "keys" as columns in a Sisense widget. Example: Lets say we have a semi-structure table that contains some json attributes which is some key:value pairs attributes:{ "x1": "John Doe", "x2": 30, "x3": 180 }is there a way I use "x2" in my widgets (eg: line chart) without me creating/hard-code into columns on the database/model level?

Assaf Hanina · Accepted Answer

Hey ramansingh89 , On a dashboard level it might be possible using the Custom Code Transformation Feature.the Transformation can be done on a widget level. However, it's more common to normalized the data directly in the Data Source to reduce the Computation on the Users level and provide more flexibility.For Elasticubes, Custom Code Feature provide the ability to retrieve the Json Data and Transform it to a Data Frame, which is then returned as a table within the data model with norma...