Forum Discussion

ramansingh89's avatar
ramansingh89
ETL
11-15-2024
Solved

Expose JSON Key in a widget

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...
dashboards & reporting
  • AssafHanina's avatar
    AssafHanina
    11-20-2024

    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 normalized data.
    Transforming the data directly in the data model simplifies drag-and-drop operations, enhances filtering capabilities, and allows for more advanced data manipulations.

    Both Features are based on Python Jupyter Notebooks.

    Best Regards

    fyi DRay 

AssafHanina's avatar
AssafHanina
Sisense Employee
11-20-2024

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 normalized data.
Transforming the data directly in the data model simplifies drag-and-drop operations, enhances filtering capabilities, and allows for more advanced data manipulations.

Both Features are based on Python Jupyter Notebooks.

Best Regards

fyi DRay