01-30-2020 08:08 AM
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.
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
},
}
]