cancel
Showing results for 
Search instead for 
Did you mean: 

Objects From Array

sjakathi
New Contributor II

Hi ,
Can you please help me to get the objects from the array as below.The LX segment is dynamic in the below example it is having 2 but it will be varying.
This is my Input
[
{
“order_edi”: [
“LX|000001”,
“W01|1|EA||IN|53142262|UP|642470202104||||||||VN|ER3333-03-abcd”,
“G69|description”,
“N9|VC|A901”,
“N9|SZ|64-120”,
“N9|CH|068-07-04338”,
“W20|1|0|EA”,
“LX|000002”,
“W01|1|EA||IN|53142262|UP|642470202104||||||||VN|ER222-03-efgh”,
“G69|Description”,
“N9|VC|A301”,
“N9|SZ|66-120”,
“N9|CH|068-07-02338”,
“W20|1|0|EA”,
]
}
]

I want the output as below.
{
“order_edi”: “LX|000001”,
“W01|1|EA||IN|53142262|UP|642470202104||||||||VN|ER3333-03-abcd”,
“G69|description”,
“N9|VC|A901”,
“N9|SZ|64-120”,
“N9|CH|068-07-04338”,
“W20|1|0|EA”
}
{
“order_edi”:
“LX|000002”,
“W01|1|EA||IN|53142262|UP|642470202104||||||||VN|ER222-03-efgh”,
“G69|Description”,
“N9|VC|A301”,
“N9|SZ|66-120”,
“N9|CH|068-07-02338”,
“W20|1|0|EA”
}

1 REPLY 1

spinaka
New Contributor III

You can make it this way.
image
SP new pipeline 10_2021_10_25.slp (5.1 KB)