Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

can we convert the data in log file into table format using qlikview

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?

loveisfailtresescocleveranjos

Thanks

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

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

View solution in original post

7 Replies
marcus_sommer

Take a look on this tool: http://qlikviewcookbook.com/download/script-log-analyzer/ from Rob Wunderlich.

- Marcus

Clever_Anjos
Employee
Employee

Could you provide a sample of your files?

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

Hi Clever Anjos

please find the files attached

Clever_Anjos
Employee
Employee

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

Not applicable
Author

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