Edit Table using a pivot of a table

Edit Table using a pivot of a table

  

I got a table in like such:

Id,size,qty,cost

Data:

1,S,9,3
2,M,10,3
3,L,11,3


The grid they want to edit data is something like this. Where the number of columns will be dynamic based on number of sizes and text for each row as well.

S   M    L
9   10   11


Possible?


Thanks in advance

There is definitely a way to do this to show the data, but I don't think there is a simple way to do it, and I'm not sure if you will be able to get the data to work with the Edit Table.

Here is a forum post where they used SQL PIVOT to pivot the information. You'll have to create a structure to hold the information that goes in each row.

The next hard part would be how you update the information considering it will be held in a structure that does not represent the original data you want to update.

Don't have a full solution for you but hope this gets you started.

Hi Rick,

Have you checked out this pivot table forge component:

https://www.outsystems.com/forge/1141/

It should help you achieve what you described.

Thanks,

Justin