Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
Employee
Employee

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

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
MVP & Luminary
MVP & Luminary

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

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

- Marcus

Employee
Employee

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

Could you provide a sample of your files?

Not applicable

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

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

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

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

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

Hi Clever Anjos

please find the files attached

Employee
Employee

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

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

Not applicable

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

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