topic Loading multiple QVD files and rowno() in QlikView

Loading multiple QVD files and rowno()

Tue, 01 Mar 2011 08:18:05 GMT

Hi All,

I am loading multiple QVD files.I have 4 QVD files which has 8 records. I am putting rowno() funtion to generate line no which is showing 26 records where as all QVD files have only 8 records, I am attaching the screen-shot of the activity.

Please let me know do you want all other files like CSV files, QVD files and QVW files.

Thanks

Samir

Loading multiple QVD files and rowno()

maneshkhottcpl — Tue, 01 Mar 2011 08:29:55 GMT

Hi ,

Just try this one and not success then send me ur file with application.

For each File in filelist('D:\QlikView_Pratice\Loading-multiple-QVD-files\CSV-Files\*.csv')

TableName:

LOAD

FROM

[$(File)]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//STORE TableName INTO $(File). qvd (qvd);

Next

STORE TableName INTO $(File). qvd (qvd);

Loading multiple QVD files and rowno()

maneshkhottcpl — Tue, 01 Mar 2011 08:32:11 GMT

Sorry ignore previous one,

Just try this one and not success then send me ur file with application.

For each File in filelist('D:\QlikView_Pratice\Loading-multiple-QVD-files\CSV-Files\*.csv')

TableName:

LOAD

FROM

[$(File)]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

STORE TableName INTO $(File). qvd (qvd);

drop table TableName;

Next

Loading multiple QVD files and rowno()

Tue, 01 Mar 2011 09:11:50 GMT

Thanks Mahesh, your suggestion worked for me.

Once agian, heartiest thanks for your attention.

Loading multiple QVD files and rowno()

Sun, 13 Mar 2011 14:49:29 GMT

Hi Mahesh,

It will generate the qvd and will place the file in the following folder:

'D:\QlikView_Pratice\Loading-multiple-QVD-files\CSV-Files'

I want to more qvd file to some other folder like:

''D:\QlikView_Pratice\Loading-multiple-QVD-files\QVD-Files'

How can I move file to another location?

Thanks

Samir

Loading multiple QVD files and rowno()

maneshkhottcpl — Sat, 19 Mar 2011 03:23:45 GMT

Hi,

U can use the

Store TableName into Path\FileNAme.qvd;

Path is ur physical path(Full)

Loading multiple QVD files and rowno()

Sun, 20 Mar 2011 17:38:52 GMT

Hi Mahesh,

I got the answer from Jonathan, meanwhile I am writing my requirement and where are you wrong:

**************************************************************************************************************************

For each File in filelist('D:\QlikView_Pratice\Loading-multiple-QVD-files\CSV-Files\*.csv')

TableName:

LOAD

FROM

[$(File)]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

STORE TableName INTO $(File).qvd (qvd);

drop table TableName;

************************************************************************************************************************

here if you will debug the code , will find file name as whole path in "$(File);"

So, we can not use it here. filename() function is also not working here

So, take substring function and find the file name and store into the desired path.

I will forward you the Jonathan's code or link later.

Thanks

Samir