Loading data from multiple paths

[#1]

Hi all,

i need to load data from multiple file placed in multiple paths.how i can acheive this through single FROM statement.

EX:

load * from

thanks in advance..

[#2]

Hi jagan,

i cannot create multiple concatenate,bcoz the total actual  files are 17.

[#3]

can u pls tell what i need to specify in =$(vPathFile)]; and SQLCOLUMNS;

[#4]

hi ,

can any one tell me some solution

[tresesco]

Sorry, a recursive call would be required. Try like:

SUB FindSubDir (Path)

     FOR Each File in filelist (Path&'\*.csv')

          LOAD
                *

           From [$(File)] (txt, codepage is 1252, embedded labels, delimiter is '\t', msq) ;

     NEXT File

     FOR Each Dir in dirlist (Path&'\*' )

          call FindSubDir(Dir)

     NEXT Dir

ENDSUB

CALL  FindSubDir('D:\Exchange \')

[#6]

Hi,

is any thing else i need to declare in script?

i mean i need to write like

let  path=...?