Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a qvw file that daily creates 3 qvd files.
I want to keep the procedure but not the data.
I have read that I need to drop the table:
Where do i drop the table? After each store? Would it be better to do it after all loads?
for example:
fred:
SQL SELECT *
FROM [directory\file];
STORE
fred INTO[fred] (qvd) ;
drop fred;
john:
SQL SELECT *
FROM [directory\file];
STORE
john INTO[john] (qvd) ;
drop john;
Thank you
Jo
Tested Done
Check from your end with Proper Path of stored location
Sample:
LOAD * Inline [
FiscalYear, ServiceType, Field
FY13, Type3, 13
Fy13, Type4, 25
FY14, Type3, 29
FY14, Type4, 42
FY15, Type1, 1
FY15, Type2, 5
FY15, Type3, 68
FY15, Type4, 56
];
STORE Sample into C:\Users\XXX\Downloads\Sample.qvd (qvd);
DROP Table Sample;
Sample1:
LOAD * Inline [
Name, Amount
bala, 20
bala, 10
satheesh, 15
satheesh, 15
madhu, 14
];
STORE Sample1 into C:\Users\XXX\Downloads\Sample1.qvd (qvd);
DROP Table Sample1;
Data Model Seems Empty, Now. In future, If you want to use same thing of QVD it should work
I have a qvw file that daily creates 3 qvd files.
I want to keep the procedure but not the data.
I have read that I need to drop the table:
1) Where are the 3 qvd's. Here, I've seen only 2 Qvd's
2) Procedure and Keep is fine but what is the use to do store of QVD
3) Will help you, If you explain first Two
Hi Anil
1. the 3rd QVD file follows the same format:
2. I store the rows into a QVD file for use by another QVW file
3. Thanks
If your table structure for all 3 QVDs is exactly same then after each reload they will Auto Concatenate if you dint mention noconcatenate() function before second and 3rd Table reload.
If you are storing tables seperately, its better to drop those reloaded table after each individual table load.
Tested Done
Check from your end with Proper Path of stored location
Sample:
LOAD * Inline [
FiscalYear, ServiceType, Field
FY13, Type3, 13
Fy13, Type4, 25
FY14, Type3, 29
FY14, Type4, 42
FY15, Type1, 1
FY15, Type2, 5
FY15, Type3, 68
FY15, Type4, 56
];
STORE Sample into C:\Users\XXX\Downloads\Sample.qvd (qvd);
DROP Table Sample;
Sample1:
LOAD * Inline [
Name, Amount
bala, 20
bala, 10
satheesh, 15
satheesh, 15
madhu, 14
];
STORE Sample1 into C:\Users\XXX\Downloads\Sample1.qvd (qvd);
DROP Table Sample1;
Data Model Seems Empty, Now. In future, If you want to use same thing of QVD it should work
thank you - the syntax was
DROP Table xxx;
I did it after every individual load.
Jo