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

    Create separate fields from multiline record

    cferguso _

      Is there a way to create separate fields using data from multilines of a record?

       

      Here is a example of what I would like to do:

       

      Data:

       

      Acct#  ---Date- Refer # Sc  Rn  Ln # Description 

      00103  4/4/1996 0090013 05  96  0001 PIA

      00103  4/4/1996 0090013 05  96  0002 INS-973

      00103  4/4/1996 0090013 05  96  0003 INS-904

      00103  4/4/1996 0090013 05  96  0004 INS-909

      00103  4/4/1996 0090013 05  96  0005 INS-400A

      00104  1/1/1994 0090019 12  41  0001 BEA-None

      00104  1/1/1994 0090019 12  41  0002 AAA-W09

      00104  1/1/1994 0090019 12  41  0003 ATM-None

                          

       

       

      Disired Result:

      Acct   Date Refer # Sc  Rn  Desc 1  -Desc 2 -Desc3 -Desc 4  Desc 5

      00103  4/4/1996 0090013 05  96  PIA       INS-973 INS-904  INS-909  INS-400A

      00104  1/1/1994 0090019 12  41  BEA-None  AAA-W09 ATU-None

       

      Also each record does not have the same number of lines.

       

      Any help would be appreciated.

       

      Thanks

        • Create separate fields from multiline record
          Olly Bond

          Hello cferguso,

           

          If you just grab everything on a single line template, then create a summary, and simply select "suppress duplicate values" on the display tab for at least one key column, say Acct#.

           

          Then export this summary as a fixed width text file and open the export as a report in Monarch. You'll then be able to trap so as to distinguish between the first line of data and the subsequent lines for each Accnt#.

           

          (Sorry, I realise that was a bit rushed, as explanations go...) On the second pass, trap just the first line, and for the final field, set the advanced field properties to end on "none of the above". This will let you see the data as you want it in the table.

           

          Best wishes,

           

          Olly