Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a problem, I have to load the lines of a log file but when I load it in the usual way, if in the file there is a field with "something" inside it qlik blocks loading to the previous line. Do you know if there is a system or 1 option to insert between those to eliminate the header or give it the type of separator? attached I send you what I did:
tabella:
LOAD @1 as Server_Started,
@2 as Timestamp,
@3 as Document,
@4 as Type,
@5 as User,
@6 as Message,
@7 as Id,
@8 as Session
FROM D:\Qlikview_Log\Audit_QLIK-NPRINTING_$(v_anno)-$(v_mese).log (txt, codepage is 1252, no labels, delimiter is ' ', msq, header is 1 lines);
Thx a lot