Hi, I need to perform a cross-tab of data in Progress 4GL.
I have a table like this, it's called sales:
seq city date sold
----------------------------
1 New York 02/01/07 123
1 New York 03/01/07 125
1 New York 04/01/07 128
1 New York 05/01/07 132
1 New York 06/01/07 140
1 New York 07/01/07 153
1 New York 08/01/07 160
1 New York 09/01/07 160
1 New York 10/01/07 175
1 New York 11/01/07 173
1 New York 12/01/07 181
1 New York 01/01/08 188
2 Chicago 02/01/07 43
2 Chicago 03/01/07 46
2 Chicago 04/01/07 47
2 Chicago 05/01/07 51
2 Chicago 06/01/07 53
2 Chicago 07/01/07 55
2 Chicago 08/01/07 57
2 Chicago 09/01/07 56
2 Chicago 10/01/07 63
2 Chicago 11/01/07 68
2 Chicago 12/01/07 73
2 Chicago 01/01/08 75
What I need is to spread the data horizontally, like shown below:
seq city 02/01/07 03/01/07 04/01/07 05/01/07 .....
---------------------------------------------------------
1 New York 123 125 128 132 .....
2 Chicago 43 46 47 51 .....
Any help is much appreciated.
I have a table like this, it's called sales:
seq city date sold
----------------------------
1 New York 02/01/07 123
1 New York 03/01/07 125
1 New York 04/01/07 128
1 New York 05/01/07 132
1 New York 06/01/07 140
1 New York 07/01/07 153
1 New York 08/01/07 160
1 New York 09/01/07 160
1 New York 10/01/07 175
1 New York 11/01/07 173
1 New York 12/01/07 181
1 New York 01/01/08 188
2 Chicago 02/01/07 43
2 Chicago 03/01/07 46
2 Chicago 04/01/07 47
2 Chicago 05/01/07 51
2 Chicago 06/01/07 53
2 Chicago 07/01/07 55
2 Chicago 08/01/07 57
2 Chicago 09/01/07 56
2 Chicago 10/01/07 63
2 Chicago 11/01/07 68
2 Chicago 12/01/07 73
2 Chicago 01/01/08 75
What I need is to spread the data horizontally, like shown below:
seq city 02/01/07 03/01/07 04/01/07 05/01/07 .....
---------------------------------------------------------
1 New York 123 125 128 132 .....
2 Chicago 43 46 47 51 .....
Any help is much appreciated.