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

Not able to create JSON Array

kumar25
New Contributor II

Hi,

I have a list of JSON objects, trying to add them to an array. Not able to do so, can some help in how to do that.

Input:
[
{
โ€œaโ€:โ€œ101โ€,
โ€œbโ€:โ€œ102โ€,
โ€œcโ€:โ€œ103โ€
},
{
โ€œaโ€:โ€œ201โ€,
โ€œbโ€:โ€œ202โ€,
โ€œcโ€:โ€œ303โ€
},
{
โ€œaโ€:โ€œ301โ€,
โ€œbโ€:โ€œ302โ€,
โ€œcโ€:โ€œ303โ€
}
]

Expected Output:
{
โ€œvaluesโ€:[
{
โ€œaโ€:โ€œ101โ€,
โ€œbโ€:โ€œ102โ€,
โ€œcโ€:โ€œ103โ€
},
{
โ€œaโ€:โ€œ201โ€,
โ€œbโ€:โ€œ202โ€,
โ€œcโ€:โ€œ303โ€
},
{
โ€œaโ€:โ€œ301โ€,
โ€œbโ€:โ€œ302โ€,
โ€œcโ€:โ€œ303โ€
}
]
}

2 REPLIES 2

nsingam
Employee
Employee

Hi @kumar25,

You can you the Group By N snap and set the Group Size to 0 and Target field to values.

kumar25
New Contributor II

Hi @nsingam โ€ฆ It worked. Thanks