Loading all log file with ftp

Mon, 08 Feb 2010 02:18:15 GMT

Hi all

Our customer had Unix System

There are some log files and we need all

Unfortunately, generated unknown file name.

Everybody known as follwing ...How to load all files with ftp

Anybody a suggestion?


// example 1 - list all log related files on disk
EXT = 'log'
sub DoDir (Root)
 for each File in filelist (Root&'\*.'&EXT)
LOAD @1, @2, @3 FROM '$(File)'
 (txt, codepage is 949, no labels, delimiter is ',', msq);
next File
end sub

call DoDir ('C:\T')



// example 2 - load log with ftp

 set filename=2010-02-08_1123.log;
 LOAD @1, @2, @3 FROM [ftp://$$$:$$$@11.6.11.2/$(filename)]
 (txt, codepage is 949, no labels, delimiter is ',', msq);

Loading all log file with ftp

Mon, 08 Feb 2010 02:29:02 GMT

I think this way...but It's be unsuccessful


for each File in filelist ('ftp://***:***@211.236.4.1/*.log')
 LOAD @1, @2, @3 FROM 'ftp://***:***@211.236.4.1/$(File)'
 (txt, codepage is 949, no labels, delimiter is ',', msq);
next File

topic Loading all log file with ftp in QlikView

Loading all log file with ftp

Loading all log file with ftp