create csv from json : How can i turn rows into columns?

[hans-smeets]

Good morning,

I have an array with a number of values, there are represented as row, with a type and a value. I need to feed this into an existing automation, but that reads the test types as coluns and the rows as values.

I have been using the creat csv table object in combination with parse json. That does extract the data, but in the wrong layout.
The sample json is:

When i do create csv table and write it to file, what I get is:

but what i need is:

If it was just excel, I could do a transpose, but since it feeds directly into an automation , I cant do it manualy and it would be to much to do manually anyway.

Does anyone have any idea how to tackle this problem, I am not even sure where to start.

Cheers

Hans

[lbendlin]

Please rethink your approach. Your intended output format will be a nightmare for the downstream system, especially with variable number of columns.

[hans-smeets]

The intented output format will work with the down streamsystem, since it already does that.

The problem I have is the fact our supplier is switching to an api and that is how it presents the data to us. I do not have the option to change either our suppliers API or our down stream system, so I will just have to transpose the data somehow. I know which columns it will be so I can code those.

If you have a hint of a better aproach I'd love to hear it, but it has to end up in the output format I gave as a sample, i litearlly do not have a choice.

[lbendlin]

Message 5 in this post seems to be doing what you need.

Solved: I need help transposing data into a usable array. - Power Platform Community (microsoft.com)

[hans-smeets]

In my screen post 5 is the topic starter supplying some extra info, what was the username of the one you referred to, the one by user: v-litu-msft?

[lbendlin · Accepted solution]

This one Solved: Re: I need help transposing data into a usable arr... - Power Platform Community (microsoft....