Forum Discussion
Combine rows in a table with equal columns
Hi, I have this table, where I have multiple rows equals and the only difference between them is the Value: ID Status Desc Value 1 A xx 1,5 1 A xx 1,5 1 A xx 1 2 B a...
You can use Group By
In the query editor, right click on your ID column, and choose group by.
In the window choose advanced, and group by the 3 columns and create a sum operation for Value:
You can use Group By
In the query editor, right click on your ID column, and choose group by.
In the window choose advanced, and group by the 3 columns and create a sum operation for Value: