8
Views
1
Comments
How to merge rows with the same value from sql result
Question

Hello everyone

How to implement my requirement like the picture as below

This is original data

to approach my requirement firstly I created an sql

SELECT {Estimation}.[OpportunityId],
    {Estimation}.[EstimationDate],
    {Estimation}.[Amount],
    sum({Estimation}.[Amount]) over (PARTITION BY {Estimation}.[OpportunityId],{Estimation}.[EstimationDate]) AS TotalAmount
FROM {Estimation}

This is my SQL result

This is my result shown on the screen

Appreciate if someone can provide me help on this, thanks very much.

imagefile.xlsx

mvp_badge
MVP
Rank: #112

Hi May,

Here is one similar post on forum with solution. You can try this.

https://www.outsystems.com/forums/discussion/36072/merge-cell-table-record/