Modify Profile Snap output category to separate Object

[neeraj_talreja]

Hi Team, I am new to Snaplogic tool. We have a requirement where we need to load the output of Profile Snap into a table. Each entry from profile snap will be having a row in the table. So I am trying to find a way to split the profile output into separate object. Example is given below. I have edited in text editor under Desired Output what I am looking for.

There can be n number of columns so trying to find a solution which is dynamic in nature.

Any help is appreciated.

Profile Snap Output
[
{
“NAME”: {
“popular”: “ABCD”,
“uniqueValues”: 491,
“missingValues”: 0,
“total”: 500
},
“SHARE”: {
“mean”: 0.314,
“min”: 0,
“max”: 104,
“stddev”: 4.887041061898433,
“popular”: {
“lower”: 0,
“upper”: 10.4,
“count”: 497
},
“uniqueValues”: 6,
“missingValues”: 0,
“total”: 500
}
}
]

---

Desired Output

[
{
{
“columnName”: “NAME”,
“popular”: “1700 Pacific Ave Ste 1400 @ Penson Financial Services”
},
{
“columnName”: “NAME”,
“uniqueValues”: 491
},
{
“columnName”: “NAME”,
“missingValues”: 0
},

	{
		"columnName": "NAME",
		"total":		500
	},
---------------------------------------------------------------
	{
		"columnName": "SHARE",
		"mean":		0.314
	},
	{
		"columnName": "SHARE",
		"min":		0
	},
	{
		"columnName": "SHARE",
		"max":		104
	},
		
	{
		"columnName": "SHARE",
		"lower":		0
	},
	{
		"columnName": "SHARE",
		"upper":		10.4
	},
	{
		"columnName": "SHARE",
		"count":		497
	},
	{
		"columnName": "SHARE",
		"uniqueValues":		6
	},
	{
		"columnName": "SHARE",
		"missingValues":		0
	},
		
	{
		"columnName": "SHARE",
		"total":		500
	},

	
		
	
}

]