Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
bthatcher
New Contributor

Sharepoint Data Spliting a column in a table to text ?

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

2 Replies
Not applicable

Re: Spliting a column in a table to text ?

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

bthatcher
New Contributor

Re: Spliting a column in a table to text ?

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

Community Browser