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

Convert array to object and remove empty array

Cogenics
New Contributor

Hello experts,
Can you help me on converting array to object.
Input :-
{
โ€œabcโ€: [
{
โ€œex_1_filed_nameโ€: โ€œaโ€,
โ€œex_1_filed_Valueโ€: โ€œNโ€
},
{
โ€œex_1_filed_nameโ€: โ€œbโ€,
โ€œex_1_filed_valueโ€: โ€œYโ€
},
[
{
โ€œex_1_filed_nameโ€: โ€œcโ€,
โ€œex_1_filed_valueโ€: โ€œdโ€,
โ€œvaluidโ€: โ€œcโ€
},
{
โ€œex_1_filed_nameโ€: โ€œcโ€,
โ€œex_1_filed_valueโ€: โ€œeโ€,
โ€œvalueโ€: โ€œcโ€
}
],
[

        ],
        [

        ]
      ]

}
Expected Output :-

{
โ€œabcโ€: [
{
โ€œex_1_filed_nameโ€: โ€œaโ€,
โ€œex_1_filed_Valueโ€: โ€œNโ€
},
{
โ€œex_1_filed_nameโ€: โ€œbโ€,
โ€œex_1_filed_valueโ€: โ€œYโ€
},

          {
            "ex_1_filed_name": "c",
            "ex_1_filed_value": "d",
            "valuid": "c"
          },
          {
            "ex_1_filed_name": "c",
            "ex_1_filed_value": "e",
            "value": "c"
          }
          ]

}

1 REPLY 1

igormicev
Contributor

Hi @Cogenics,

You can check this pipeline Convert_Array_to_Object_2020_12_14.slp (4.5 KB)

/Igor