Announcements
Hello,
Below is a collection.
using the above, need to generate output like below
Need solution to the problem.
Regards
Hi,
Have you tried using GroupBy? it may resolve your problem, if you need further assistance, please let me know
Paramter column values are dynamic or limited set of values
Hi @developerAJ ,
Parameter column values are dynamic.
Hi @victorcp ,
I tried GroupBy, but not sure where is the issue. Parameter column values are dynamic.
I did a demo to you showing how you can do it with GroupBy:
First I created a gallery and the items property I set it as:
GroupBy( colTest, "Account ID", "Group" )
Then I created another gallery inside the first one to show the respective Parameters
and that is it, any doubts let me know
The output i need is different. If there are multiple rows of an Account ID, then the columns like Parameter, Score should be like Parameter1, Parameter2... , Score1, Score2... (In Horizontal manner but inside a gallery)
columns can't be dynamic in order to achieve transformation you are looking for you need to used Addcolumns function but it does not support dynamic column names . it should be hardcoded parameter1 , parameter2 but in your case its dynamic and it gets increased. i am not sure if there is any another way.
Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
You can connect with me on LinkedIn
As @developerAJ said, there is no easy way of creating dynamic column, so the only way is creating a table and refer it using groupby.
If you want to display the info like columns just use a horizontal gallery.
If you need anything else let me know
Hello @victorcp and @developerAJ ,
Thanks. The logic you both suggested works for me.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 354 Super User 2026 Season 2
M Bilal Khan 320
Mohsin Ali 246
