topic Re: Loading data from multiple paths in QlikView

Loading data from multiple paths

Thu, 21 May 2015 10:50:20 GMT

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

Re: Loading data from multiple paths

its_anandrjs — Thu, 21 May 2015 10:56:33 GMT

Hi,

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

Regards,

Anand

Re: Loading data from multiple paths

sunny_talwar — Thu, 21 May 2015 10:56:33 GMT

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

Best,

Sunny

Re: Loading data from multiple paths

Thu, 21 May 2015 11:00:29 GMT

Hi ,

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

Re: Loading data from multiple paths

tresB — Thu, 21 May 2015 11:00:40 GMT

Try like:

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

LOAD

Autogenerate 1;

NEXT File

Re: Loading data from multiple paths

Thu, 21 May 2015 11:05:39 GMT

can u pls tell me in detail

Re: Loading data from multiple paths

jagan — Thu, 21 May 2015 11:05:44 GMT

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.

Re: Loading data from multiple paths

rakesh_kumar — Thu, 21 May 2015 11:06:14 GMT

Hi,

This post could be of help to you:

Loading data from multiple xls-files from folder with subfolder

Regards,
RK

Re: Loading data from multiple paths

Thu, 21 May 2015 11:06:40 GMT

Hi tresesco,

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

Re: Loading data from multiple paths

manojkulkarni — Thu, 21 May 2015 11:09:08 GMT

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;

Re: Loading data from multiple paths

Thu, 21 May 2015 11:09:21 GMT

Hi jagan,

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

Re: Loading data from multiple paths

Thu, 21 May 2015 11:18:08 GMT

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

Re: Loading data from multiple paths

Thu, 21 May 2015 11:45:10 GMT

hi ,

can any one tell me some solution

Re: Loading data from multiple paths

tresB — Thu, 21 May 2015 12:57:46 GMT

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 \')

Re: Loading data from multiple paths

Thu, 21 May 2015 13:45:01 GMT

Hi,

is any thing else i need to declare in script?

i mean i need to write like

let path=...?