0

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!

0 Answers0