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

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

Thu, 06 Oct 2016 11:02:45 GMT

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

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

marcus_sommer — Thu, 06 Oct 2016 11:51:51 GMT

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

- Marcus

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

Clever_Anjos — Thu, 06 Oct 2016 12:19:18 GMT

Could you provide a sample of your files?

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

Thu, 06 Oct 2016 12:22:31 GMT

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

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

Thu, 06 Oct 2016 12:29:46 GMT

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

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

Thu, 06 Oct 2016 13:49:30 GMT

Hi Clever Anjos

please find the files attached

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

Clever_Anjos — Thu, 06 Oct 2016 23:38:30 GMT

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

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

Fri, 07 Oct 2016 07:48:58 GMT

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