I'm importing a JSON into a table sheet. But when I import with JMESPath, the system creates columns for each {date_time}. I tried to create a filter with JMESPath, but I still can't!
Is there anyone here who can help me?
I think of two options: convert in a JSON array or create a JMESPath filter for this!
{
"viewsData":{
"2022-10-01 00:00":{"play":17,"unique_play":17,"unique_view":28,"view":28},
"2022-10-01 10:00":{"play":14,"unique_play":14,"unique_view":18,"view":20},
"2022-10-01 11:00":{"play":8,"unique_play":8,"unique_view":17,"view":19},
},
"totalPlays":234,
"totalViews":402,
"totalUniqueViews":352,
"totalUniquePlays":224
}
When I Import to the table, the JMESPath creates columns, don't row!