Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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;