Transpose collection record with multiple columns to rows

(0) Share

Report

Posted on by steshepherd

I've tried to google this and looked on her, but can't find a solution to something that seems like it 'should' be easy....

I have a collection (filtered to only bring back 1 record), that has a number of columns.

ID	score 1	score 2	score 3	score 4
100	2	4	4	8

to create a spider chart, I need to give it data like this

Score name	Score
score 1	2
score 2	4
score 3	4
score 4	8

I was using PowerBi previously to do the transformation but I can't use it so need a new solution. I have a component that I found online for a spider chart and now need to build the data for it

Any ideas?

Thanks

Categories:

General Questions

All responses (1)

Answers (1)

Verified answer

Lisa3 46 on at

Like (0)

Report

Re: Transpose collection record with multiple columns to rows

Take the item from the first collection to make a second collection with a line for each score.
ClearCollect(collection2,
{'Score name': "score 1",
Score: First(collection1).'Score 1'},
{'Score name': "score 2",
Score: First(collection1).'Score 2'})