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