Forum Discussion

mohit_jain's avatar
mohit_jain
New Contributor III
2 years ago

JSON STRING VALUES INTO COLUMNS

Hi Everyone..

I have a requirement where we have to split the json which is coming into the json but it is in String. We have to divide into the columns.

Let me explain you by the example. 
The Json is coming in this format.

[
{
"String":
"{col_name=CTRY_CODE, data_type=varchar(32768)},{col_name=SRCE_CODE, data_type=varchar(32768)},{col_name=PROD_CODE, data_type=varchar(32768)}}}"
}
]

 

But the result we need is :

Can anyone help me to solve this.

Thanks in advance.

alchemiz j_angelevski