Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

amit_saini
Honored Contributor 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
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

amit_saini
Honored Contributor 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

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
Community Browser