Forum Discussion

rbikash7758's avatar
rbikash7758
New Contributor III
7 years ago

How to split column values into new row

Hi Guys ,

I have below given json as input and i wanted to spilt it into difference rows based on multi valued columns .

Input: “Cost_Center_Hierarchies”: [
{
“Fucntional_Lvl4”: “CC6140”,
“F_Lvl_4_Descr”: “Corporate - G&A”
},
{
“Fucntional_Lvl4”: “SF509”,
“F_Lvl_4_Descr”: “Corporate - G&A”
}
],
“Business_Unit_ID”: “LOB0022”,
“Business_Unit”: “Corp LiveRamp Dedicated LOB BU”,
“Cost_Center_ID”: “C6001”,
“Cost_Center_Name”: “C6001 Restructuring”

output :
Row-1
“Fucntional_Lvl4”: “CC6140”,
“F_Lvl_4_Descr”: “Corporate - G&A”
“Business_Unit_ID”: “LOB0022”,
“Business_Unit”: “Corp LiveRamp Dedicated LOB BU”,
“Cost_Center_ID”: “C6001”,
“Cost_Center_Name”: “C6001 Restructuring”

 Row-2
 "Fucntional_Lvl4": "SF509",
 "F_Lvl_4_Descr": "Corporate - G&A"
 "Business_Unit_ID": "LOB0022",
 "Business_Unit": "Corp LiveRamp Dedicated LOB BU",
 "Cost_Center_ID": "C6001",
 "Cost_Center_Name": "C6001 Restructuring"  

Please suggest.

Thanks,
Biksah