Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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);
The problem is I'm taking the DocLocation field from the first table so none of the fields cotain the same information