aggregate merging rows

aggregate merging rows

  

How can I change this in a way that al the dates are in one row behind the same Patchname?


Kind Regards, 


Martin Rozeboom

Hi Martin,

Try to add the MAX-function instead of the Group function on the columns with the if()-function. The Patch column is correct.

Kind regards,

Remco

Acctually the Original database looks like: 

What I want is to show which patch is created in which Database. I used If(DATABASE = "cogasp01", AUD_CREATIE_DATUM, " ") to change the table into a form in which is shown in my first post. But now I want to show the creatiedates in one row. 


I know I do something wrong, but I don't know how to fix it.


Regards, 


Martin


Depends what you want to do, but imho, a simple advanced query will make it easier?


I want an easy way to show, which patch isn't installed in which DB. 


J. wrote:

Depends what you want to do, but imho, a simple advanced query will make it easier?




Well,

 you have to pivot the table i think.


Does That work in Outsystems? And how should I do That?


J. wrote:

Well,

 you have to pivot the table i think.




Like I said before, use advanced queries.


Mind you, the limitation is in the fact you cannot pivot dynamically, you have to know upfront how many columns you end up with.


Thanks, I will try to do it with some changes in the Preparation first.