2 Replies Latest reply: Aug 24, 2012 8:54 AM by Brett Thatcher RSS

    Sharepoint Data Spliting a column in a table to text ?

    Brett Thatcher

      I'm trying to split a column form a table to break the infoamtion 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);

        • Re: Spliting a column in a table to text ?
          Felim Shanaghy

          Fields in Qlikview are linked via Similar named Fields (your primary key) example below, ofc I don't know your key fields

           

          LOAD SiteId AS PRIMARY_KEY,
              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 AS PRIMARY_KEY,
               @2,
               @3,
               @4,
               @5,
               @6,
               @7,
               @8
              
              
          FROM_FIELD
          (AuditData, DocLocation)
          (txt, utf8, no labels, delimiter is '/', msq);