topic Sharepoint Data Spliting a column in a table to text ? in QlikView

Sharepoint Data Spliting a column in a table to text ?

Anonymous — Fri, 24 Aug 2012 11:42:24 GMT

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 ?

Fri, 24 Aug 2012 12:08:46 GMT

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);

Re: Spliting a column in a table to text ?

Anonymous — Fri, 24 Aug 2012 12:54:42 GMT

The problem is I'm taking the DocLocation field from the first table so none of the fields cotain the same information