Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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);
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
Thanks Mahesh, your suggestion worked for me.
Once agian, heartiest thanks for your attention.
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
Hi,
U can use the
Store TableName into Path\FileNAme.qvd;
Path is ur physical path(Full)
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