3 Replies Latest reply: Sep 5, 2012 12:32 PM by Brett Thatcher RSS

    Linking a text import from a table back to the original table

    Brett Thatcher

      I'm trying to split a column from a table to break the information down. When I use the script below it creats a new table containing the infomation I want. However it doesn't seem to link back to the original table.

      Is there any way that I can either create a link between the two tables or recombine the two tables back into one?

       

       


      LOAD SiteId,
          ItemId,
          ItemType,
          UserId,
          LocationType,
          Occurred,
          Year(Occurred) AS Year,
          Month(Occurred) AS Month,
          Event,
          EventSource,
          MachineName,
          MachineIp,
          DocLocation,
          EventName,
          SourceName,
          EventData;
      SQL SELECT *
      FROM "Portal21_Site".dbo.AuditData;


      //****Split Doc Location********

      LOAD
        @1,
           @2,
           @3,
           @4,
           @5,
           @6,
           @7,
           @8
          
          
      FROM_FIELD
      (AuditData, DocLocation)
      (txt, utf8, no labels, delimiter is '/', msq);