topic Load .log files in QlikView in QlikView

Load .log files in QlikView

amit_saini — Mon, 13 Apr 2015 05:19:28 GMT

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,

Re: Load .log files in QlikView

Mon, 13 Apr 2015 05:31:28 GMT

hi,

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

Sheet id should be same.

Regards

Vimlesh

Re: Load .log files in QlikView

amit_saini — Mon, 13 Apr 2015 05:40:54 GMT

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,

Re: Load .log files in QlikView

jonathandienst — Mon, 13 Apr 2015 06:00:34 GMT

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?