Pivot table with date

Applications Grid / Reports
#1

Hi everyone

I’d like to make pivot table with data bellow.
If I know how to do with PHP I’d like to try to to this with the scriptcase tools.

The data look like that :

Employe / Action / Date
E1 / A1 / 2017-12-01
E1 / A2 / 2018-04-02
E2 / A1 / 2015-08-12
E2 / A3 / 2014-09-15
E3 / A2 / 2015-07-12
E3 / A4 / 2014-02-15
…

I’d like this pivot result

Employe / ------A1----- / -------A2------ / -----A3------ / ------A4-----
E1 --------/ 2017-12-01 / 2018-04-02 / ----------------/-----------------
E2 --------/ 2015-08-12 / ----------------/ 2014-09-15 /-----------------
E3 --------/ ----------------/ 2015-07-12 / ----------------/ 2014-02-15

thanks a lot for your help :slight_smile:

#2

Yes, SC can do it. Just must create your sql with group by and type app: Ressume

#3

Thanks for yor awnser.

Thanks for your answer.
With the sc resume I’ve got only the number of records, not the full date.
there’s probably something I do wrong… :-/

Employe / ------A1----- / -------A2------ / -----A3------ / ------A4-----
E1 --------/ --------1 -----/ --------1------- / ----------------/-----------------
E2 --------/ --------1 -----/ ----------------/ --------1 -----/-----------------
E3 --------/ ----------------/ --------1 ----- / ----------------/ --------1 -----