Dynamic import with wild match

mbp198 — Mon, 18 Jan 2016 21:56:50 GMT

dataimport:
LOAD @1 AS CoCd,
@2 AS Period,
@3 AS [Doc. Date],
@4 AS [Pstng Date],
@6 AS Reference,
@7 AS DocumentNo,
@8 AS Crcy,
@9 AS Year,
@10 AS [Doc. Type]
FROM

\\cagta5454\Indirect\Clients\\zz Work-in-Progress\2014\data\*_110_*GLDetl*

I want help in dynamic import of a file

currently file is located at

\\cagta5454\Indirect\Clients\\zz Work-in-Progress\2014\data\*_110_*GLDetl*

I am looking for a way so that I can able to do dynamic import

something like creating a variable

$dataLocation = \\cagta5454\Indirect\Clients\\zz Work-in-Progress\2014\data\*_

and $datafiles = '110','121','141'

so that instead of using number for the file containing data , I can use a variable

Re: Dynamic import with wild match

maxgro — Mon, 18 Jan 2016 22:33:33 GMT

maybe

set flist = '110', '111', '112';

for each f in $(flist)

set file = '\\cagta5454\Indirect\Clients\\zz Work-in-Progress\2014\data\*_$(f)_*GLDetl*';

trace $(file);

LOAD @1 AS CoCd,
@2 AS Period,

....

FROM [$(file)] ;

next;

topic Re: Dynamic import with wild match in QlikView

Dynamic import with wild match

Re: Dynamic import with wild match