Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading all log file with ftp

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);



1 Reply
Not applicable
Author

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