cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Modify Profile Snap output category to separate Object

neeraj_talreja
New Contributor

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
	},

	
		
	
}

]

0 REPLIES 0