Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have multiple log files in a folder, with the data
#Fields: date time ip method port username time-taken
2016-07-22 07:05:19 ::1 GET - 80 - ::1 760
2016-07-22 07:05:19 ::1 GET - 8443 - ::1 34
how to get this data into qlikview in a table format, with the field names as column names..
is it possible, or i have to convert the log files into excel format first than i have to load the files into qlikview?
loveisfail tresesco cleveranjos
Thanks
Please try this:
LOAD [@1:19] as TimeStamp,
[@20:33] as IP,
[@34:n] as Mesg
FROM
[a_ex*.log] (fix, codepage is 1252, no labels, header is 4 lines)
where IsNum([@1:19]);
Take a look on this tool: http://qlikviewcookbook.com/download/script-log-analyzer/ from Rob Wunderlich.
- Marcus
Could you provide a sample of your files?
Hi clever
if you dont mind,is it possible to give me your email id please?
so that i can send the files to your mail
Thanks
Hi Marcus
Thanks for the file.. This application takes only, qlikview log files or any other also.
i have given the path of my folder on my desktop in which the log files are present , but the application is getting reloaded successfully , but i am getting the message that zero log files are uploaded.
Thanks
Hi Clever Anjos
please find the files attached
Please try this:
LOAD [@1:19] as TimeStamp,
[@20:33] as IP,
[@34:n] as Mesg
FROM
[a_ex*.log] (fix, codepage is 1252, no labels, header is 4 lines)
where IsNum([@1:19]);
Thanks Clever
I have renamed the field names in the file wizard window and choosen Delimiter as space,
and I have put * for filenames to upload.. it worked
Thank you for the help