Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi and sorry for posting this question.
I'm trying to load multiple csv files from a amazon storage and I can't get the '*' to work.. and I can't understand why.
This work for a single file (but I want everything in the folder )
Shipping_EU:
Load
@1 as date
From [lib://2. Transform:Amazon_S3/qlik/import/UPS/.EU/202011061114.csv](txt, no labels, delimiter is ',');
I'm trying to use the * wildcard for the file name but this gives me an "Cannot open file: 'lib://2. Transform:Amazon_S3/qlik/import/UPS/.EU/*.csv' (Connector error: File not found)"
Shipping_EU:
Load
@1 as date
From [lib://2. Transform:Amazon_S3/qlik/import/UPS/.EU/*.csv](txt, no labels, delimiter is ',');
I have also tried looping
For each File in Filelist(vPath) Load * From [$File]
But that gives me the same result, when I specify by name it works but as soon as I want to include * instead of the file name nothing can be found.
Thanks
David
For Amazon S3 the syntax is:
LIB CONNECT TO 'Amazon_S3_Metadata';
tmpFiles:
LOAD
Key
;
SELECT
Key
FROM List
WITH PROPERTIES (
dir='SubFolder',
maxResults=''
);
for i = 0 to NoOfRows('tmpFiles') -1
let vFile = peek('Key', i, 'tmpFiles');
LOAD
*,
filename() as FileName
FROM [lib://Amazon_S3/$(vFile)] (txt, no labels, delimiter is ',');
next
For Amazon S3 the syntax is:
LIB CONNECT TO 'Amazon_S3_Metadata';
tmpFiles:
LOAD
Key
;
SELECT
Key
FROM List
WITH PROPERTIES (
dir='SubFolder',
maxResults=''
);
for i = 0 to NoOfRows('tmpFiles') -1
let vFile = peek('Key', i, 'tmpFiles');
LOAD
*,
filename() as FileName
FROM [lib://Amazon_S3/$(vFile)] (txt, no labels, delimiter is ',');
next