For example, suppose my variant column "xyz" consists of data like this:
{
"post_new_visits": "Repeat",
"post_new1_week": "Thursday",
"post_new2_appt": "Weekday",
"post_new3_site": "12:50AM",
"post_new4_channel": "5.0",
"pre_new2_appt": "Weekday",
"pre_new3_site": "12:50AM",
"pre_new4_channel": "5.0"
}
I want a new variant column from above variant column, which should only have "post*" key values, something like below,output should be like this.
{
"post_new_visits": "Repeat",
"post_new1_week": "Thursday",
"post_new2_appt": "Weekday",
"post_new3_site": "12:50AM",
"post_new4_channel": "5.0",
}
Is there any way i can acheive this?
Maybe you can flatten and re-construct the JSON. For example: