Hello good folks, I need to convert an array of JSON objects to a table in CRMA where each object is converted to a row. I'm not sure if this is exactly possible. JSON is already stored in a field. Below is the JSON structure. Is it possible to convert the array of JSON to a table/dataset using transformations or SAQL ? Please advice. [
{
"Week":"Week 1",
"Percentage":"25",
"key":"5tsnuwltt6h"
},
{
"Week":"Week 2",
"Percentage":"25",
"key":"n015nze413c"
},
{
"Week":"Week 3",
"Percentage":"25",
"key":"w21hkqa1bx"
},
{
"Week":"Week 4",
"Percentage":"25",
"key":"u96s9ttxp8"
},
{
"Week":"Week 5",
"Percentage":"50",
"key":"apcby3192fu"
},
{
"Week":"Week 6",
"Percentage":"50",
"key":"ggzg066niwa"
} ] Thanks in advance Kapil Srivatsa
@Kapil Srivatsa Bharatala as you mentioned the json is in field, So you can use string functions to get week number and percentage value in separate fields
