SQL/MX Data Mining Guide

Importing Into the Data Mining Database
HP NonStop SQL/MX Data Mining Guide—523737-001
C-5
Account History Data File
1000000,2002-11-01,Open,20000,5345.89,5345.89,0.00
1000000,2002-12-01,Open,20000,4700.00,4700.00,0.00
1000000,2003-01-01,Open,20000,1200.00,1200.00,0.00
1000000,2003-02-01,Delinquent,20000,3500.00,0.00,51.75
1000000,2003-03-01,Open,20000,5500.00,5500.00,0.00
1000000,2003-04-01,Open,20000,0.00,0.00,0.00
1000000,2003-05-01,Open,20000,6500.00,6500.00,0.00
1000000,2003-06-01,Open,20000,4590.00,4590.00,0.00
1000000,2003-07-01,Open,20000,3200.00, 3200.00,0.00
1000000,2003-08-01,Open,20000,167.89,167.89,0.00
1000000,2003-09-01,Open,20000,9800.00,9800.00,0.00
1000000,2003-10-01,Open,20000,50.00, 50.00, 0.00
1000000,2003-11-01,Open,20000,2300.78,2300.78,0.00
1000000,2003-12-01,Open,20000,5600.00,5600.00,0.00
2300000,2002-11-01,Open, 15000,0,0,0
2300000,2002-12-01,Open,15000,10000.00,1500.00,127.5
2300000,2003-01-01,Open,15000,9500.00,1500.00,120.00
2300000,2003-02-01,Open,15000,8120.00,1500.00,99.30
2300000,2003-03-01,Open,15000,12000.00,4000.00,120.00
2300000,2003-04-01,Open,15000,8120.00,4000.00,61.80
2300000,2003-05-01,Open,15000,5004.00,1500.00,52.56
2300000,2003-06-01,Open,15000,3500.00,1500.00,30.00
2300000,2003-07-01,Open,15000,4500.00,800.00,55.50
2300000,2003-08-01,Open,15000,3800.00,1500.00,34.50
2300000,2003-09-01,Open,15000,0,0,0
2300000,2003-10-01,Open,15000,0,0,0
2300000,2003-11-01,Open,15000,0,0,0
2300000,2003-12-01,Open,15000,0,0,0
2900000,2003-01-01,Open,15000,10000.00,10000.00,0
2900000,2003-02-01,Open,15000,3456.00,3456.00,0
2900000,2003-03-01,Open,15000,2300.90,2300.90,0
2900000,2003-04-01,Open,15000,9432.78,9432.78,0
2900000,2003-05-01,Open,15000,1134.00,1134.00,0
2900000,2003-06-01,Open,15000,2356.80,2356.80,0
2900000,2003-07-01,Open,15000,9870.00,9870.00,0
2900000,2003-08-01,Open,15000,8765.00,8765.00,0
2900000,2003-09-01,Open,15000,2460.00,2460.00,0
2900000,2003-10-01,Open,15000,4543.00,4543.00,0
2900000,2003-11-01,Open,15000,2000.00,2000.00,0
2900000,2003-12-01,Open,15000,5890.00,5890.00,0
3200000,2002-07-01,Open,10000,2345.00,2345.00,0
3200000,2002-08-01,Open,10000,0,0,0
3200000,2002-09-01,Open,10000,150.00,150.00,0
3200000,2002-10-01,Open,10000,5678.00,5678.00,0
3200000,2002-11-01,Open,10000,2000.00,2000.00,0
3200000,2002-12-01,Open,10000,50.00,50.00,0
3200000,2003-01-01,Open,10000,0,0,0