Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master III
Master III

Load .log files in QlikView

Hi Folks ,

I'm reading .log files from a folder which are in below format:

Script:

LOAD

......

......

    Originated,

     Originator

   

FROM

[...\Flatfiles\2015*.log]

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

Here above I'm not sure if I'm calling all these log files correct or not (e.g 2015*.log) , because my data getting double if my folder is having 2 log files , 3 times if 3 log files and so on....

Please suggest how to call all these log files in QlikView to get the exact data.

Thanks,

AS

3 Replies
Highlighted
Not applicable

Re: Load .log files in QlikView

hi,

its correct if your data field(columns) are same in all files.

Sheet id should be same.

Regards

Vimlesh

Highlighted
Master III
Master III

Re: Load .log files in QlikView

Vimlesh,

All fields are same , also when I 'm loading only one log file and doing cross check across data than it is exactly matching with log file.

Problem occurring when I'm loading more than one log file.

Thanks,

AS

Highlighted
MVP
MVP

Re: Load .log files in QlikView

The log file size is identical. Do they contain a lot of the same content?

If so, then clearly some items will be replicated multiple times.

Do you want to make sure that only one instance of an item is loaded? If so, do the items have a unique key field or fields that allow you to identify if an item has already been loaded?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein