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