Format Table Json Value Column

Queries and Resources
1

Hi, I connected an elasticsearch db to my retool app, I'm looking to format the table column single value below trying to split the json string in different columns based on the number of keys.

             "fields": {
                "column1": [
                    "name1"
                ],
                "column2": [
                    "surname1"
                ],
                "column3": [
                    "text1"
                ]
            }

the result i guess:
column1 | column2 | column3

name1 | surname1 | text1

2

:wave: Hi @fabiocremo, welcome to the community.

You should be able to do something simple like this:

formatDataAsArray(data.fields)

Assuming here that data is the json string.

Does that work for you?