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..

[its_anandrjs]

Hi,

Use multiple CSV file load functionality that may help you here.

Regards,

Anand

[sunny_talwar]

If exchange has only 4 folders named ITA, BGD, RUS and ALG then you can try this (I have never done this before and have no idea if this will work or not, but I guess there is not harm in trying )

FROM

or

Best,

Sunny

[#4]

Hi ,

i initically tried it .it is givivg  The filename, directory name, or volume label syntax is incorrect.

[tresesco]

Try like:

FOR Each File in filelist ('D:\Exchange \*.' &'csv')

     LOAD

          *

     Autogenerate 1;

NEXT File

[#6]

can u pls tell me in detail

[jagan]

Hi,

Try like this with multiple Load statements, if you loading data from only this 4 paths this is the best option

Data:

LOAD

*

FROM ;

Concatenate(Data)

LOAD

*

FROM ;

Concatenate(Data)

LOAD

*

FROM ;

Concatenate(Data)

LOAD

*

FROM ;

Hope this helps you.

Regards,

Jagan.

[rakesh_kumar]

Hi,

This post could be of help to you:

Loading data from multiple xls-files from folder with subfolder

Regards,
RK

[#9]

Hi tresesco,

script is getting executed .but i am not geeting any fields or data.

[manojkulkarni]

FOR Each File in filelist ('D:\Exchange \*.' &'csv')

FileList: 

LOAD

          *

Autogenerate 1;

NEXT File

FOR i=0 to FieldValueCount('FileList')

ODBC CONNECT to [Excel Files;DBQ=$(vPathFile)];

col:

SQLCOLUMNS;

NEXT i;

STORE col into test_col.qvd;