1 Reply Latest reply: May 15, 2014 10:05 AM by Olly Bond RSS

    Questions creating a data trap

    jclahan _

      Greetings -

       

      I've been "volunteered" to come up with a way to extract data from a legacy system and use in an Access database. Researching data mining, I've found that Monarch is the best tool for the job, but I'm having troubles setting up the trap.

       

      The report is extremely long. A copy of what it looks like "before":

       

      Date: 08/24/09                   FairyTale Airlines                   Sabre CrewTrac

      Time: 10:33                      Pairing Print Report                         Page 1

       

      Notification for:

          123456 CA DOE, JOHN                                                                     

       

      DAY DD DH C  FLTNO DPS-ARS DEPT ARRV BLKT GRNT       TBLK TDHD TCRD TPAY TDUTY LAYOVER

       

        C4101  09/15/09            BSE REPT: 0550    REPORT- 09/15/09    LOCAL Times

      Tu 15        6001 AAA-BBB 0835 1027 0152   332                                       

      Tu 15        7575 BBB-CCC 1359 1531 0132            0324 0000 0324 0324 0756 RIC  1530

        D-END: 1546  (NR 0900) REPORT 0416   DOUBLETREE DOWNTOWN        (888)555-1111     

      We 16 DH     3000 CCC-DDD 0446 0600 0114   045                                       

      We 16        3121 DDD-EEE 0645 0814 0129   036                                       

      We 16        3555 FFF-GGG 0850 1015 0125   210                                       

      We 16        8787 GGG-HHH 1225 1419 0154            0602 0000 0602 0602 1018         

        D-END: 1534                                   -


        TOTALS  BLOCK 0926 DHD 0000             CREDIT HRS. 0926   T.A.F.B.  3344

       

      Crew:

          123456 CA DOE, JOHN                                                                     

          987654 FO CLAUS, SANTA                                                                               

      741852 FA BUNNY, EASTER  /CODE

       

      This is what I'd like the final outcome to be:

       

      EMPID     DH     POSITION     LASTNAME     FIRSTNAME     DAY     DD     FLTNO     DPS     ARS     DEPT     ARRV     BLKT     GRNT

      123456          CA     DOE     JOHN     Tu     15     6001     AAA     BBB     835     1027     152     332

      123456          CA     DOE     JOHN     Tu     15     7575     BBB     CCC     1359     1531     132     

      123456     DH     CA     DOE     JOHN     We     16     3000     CCC     DDD     446     600     114     45

      123456          CA     DOE     JOHN     We     16     3121     DDD     EEE     645     814     129     36

      123456          CA     DOE     JOHN     We     16     3555     FFF     GGG     850     1015     129     210

      123456          CA     DOE     JOHN     We     16     8787     GGG     HHH     1225     1419     154     

      /CODE

       

      Any help would be greatly appreciated!

       

      Thanks.. Jon