Loading multiple QVD files and rowno()

[#1]

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

[maneshkhottcpl]

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);

[maneshkhottcpl · Accepted solution]

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

[#4]

Thanks Mahesh, your suggestion worked for me.

Once agian, heartiest thanks for your attention.

[#5]

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

[maneshkhottcpl]

Hi,

U can use the

Store TableName into Path\FileNAme.qvd;

Path is ur physical path(Full)

[#7]

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;

Next

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

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