Answered

How to rearrange Array content

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello dear community

I have the following array

[
{
"Tracking Dimension": "NPD"
},
{
"Item Model Group": "NPD"
},
{
"Item Model Group": "NPD"
},
{
"Storage Dimension Group": "NPD"
},
{
"Reservation Hieararchy": "NPD"
},
{
"Product Coverage": ""
},
{
"Batch Number Group": "",
"End Of The Month": "No"
},
{
"Flushing Principle": "Manual"
},
{
"Commodity": ""
},
{
"Customer Hierarchy": ""
},
{
"Attributes": "None"
},
{
"Conversion EA to CS": "Not existing"
}
]

I would like to rework the array below in the following way.

[
{
"Tracking Dimension": "NPD",
"Item Model Group": "NPD",
"Item Model Group": "NPD",
"Storage Dimension Group": "NPD",
"Reservation Hieararchy": "NPD",
"Product Coverage": "",
"Batch Number Group": "",
"End Of The Month": "No",
"Flushing Principle": "Manual",
"Commodity": "",
"Customer Hierarchy": ""
"Attributes": "None",
"Conversion EA to CS": "Not existing"
}
]

How do I achieve this in PA?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ellis Karim 11,933 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You can try this method:

Convert the data array into a text string, replace each occurence of the substring },{ with , (comma), then convert the result back into a (JSON) array:

json(replace(string(variables('varData')), '},{',','))

json(replace(string(variables('varData')), '},{',','))

Here is the sample runtime output:

[ { "Tracking Dimension": "NPD", "Item Model Group": "NPD", "Storage Dimension Group": "NPD", "Reservation Hieararchy": "NPD", "Product Coverage": "", "Batch Number Group": "", "End Of The Month": "No", "Flushing Principle": "Manual", "Commodity": "", "Customer Hierarchy": "", "Attributes": "None", "Conversion EA to CS": "Not existing" } ]

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

It worked nicely.
Thank you very much

Was this reply helpful? Yes No