Linking a text import from a table back to the original table
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);