SQL/MX Data Mining Guide

Creating the Data Mining View
HP NonStop SQL/MX Data Mining Guide—523737-001
3-5
Pivoting the Data
3900000 1998-10-01 1998-10-01 .00 .00 .00 Y
4098124 1998-10-01 1998-10-01 4069.34 4347.63 4596.10 Y
4300000 1999-06-01 1999-06-01 9000.00 4354.00 9876.00 N
4400000 1999-07-01 1999-07-01 .00 .00 .00 Y
4500000 1998-09-01 1998-09-01 .00 100.00 50.00 Y
4600000 1999-12-01 1999-12-01 1000.00 50.00 80.00 Y
4700000 1999-06-01 1999-06-01 330.00 330.00 330.00 N
Account
Number
... Year_
Month
Close
Month
Balance
Close_1
Balance
Close_2
Balance
Close_3
Cust
Left