Load .log files in QlikView

[amit_saini]

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

[#2]

hi,

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

Sheet id should be same.

Regards

Vimlesh

[amit_saini]

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

[jonathandienst]

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?