Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm working in a model that gets the data from some .xls files and I want to store them as .qvd.
Also what happens if the Excel book has many sheets, do I have to load each one? knowing that there is a master sheet where all the cells are routed to another cell in another sheet.
Thanks a lot!
Store TableName into [$(vRutaDatos)\TableName.qvd]
It's always a good practice to include square brackets around the file path. In this case the brackets are required because vRutaDatos contains spaces.
-Rob
tab1:
Load 8,
from path/xls
store tab1 into your location/abc.qvd
ya i believe its require to load all excel
LOAD the xls files. Write them to QVDs using the STORE statement.
Each excel sheet is loaded with a seperate LOAD statement. When you load an excel sheet, cell formulas are resolved. So if all the results exist in a single sheet, that is all you have to load.
-Rob
Hi,
so I have this code:
LOAD NIT as A02.nit_cliente,
CLIENTE,
FACTURA,
FECHA,
[VALOR NETO],
CARGOS,
[TOTAL NETO],
IVA,
[TOTAL FACTURA],
SUC,
REG,
GC,
RET.,
ICO
FROM
(biff, embedded labels, table is INICIAL$);
Then I want to STORE it. Where should I add the STORE statement?
And I have a sheet wit a lot of formulas refering to other sheets, as I understood you, I just have to call that sheet with the formulas?
Hi,
Write code some thing like
TableName:
LOAD NIT as A02.nit_cliente,
CLIENTE,
FACTURA,
FECHA,
[VALOR NETO],
CARGOS,
[TOTAL NETO],
IVA,
[TOTAL FACTURA],
SUC,
REG,
GC,
RET.,
ICO
FROM
(biff, embedded labels, table is INICIAL$);
Store TableName into TableName.qvd;
The name of table is important always give some name
Always when you make qvd it is store in your qvw file location.
let me know about this
Rgds
Anand
Hi,
ok I've already done what you told me. It worked great.
Now if I have a different distribution of the folders and I have a folder called ../03 Qvd/ and in the "Main" tab I have this code SET vRutaDatos = '..\03 Qvd\'; how can I uste the STORE statement to store the .qvd in the folder desired.
Thnx!
Hi,
You have to write a code like
Store TableName into TableName.qvd;
Store TableName into $(vRutaDatos)\TableName.qvd;
Let me know about this.
HTH
Rgds
Anand
Hi,
Your location like
SET vRutaDatos = "..\03 Qvd\";
after load statement
Store TableName into $(vRutaDatos)\TableName.qvd;
HTH
Rgds
Anand
Store TableName into [$(vRutaDatos)\TableName.qvd]
It's always a good practice to include square brackets around the file path. In this case the brackets are required because vRutaDatos contains spaces.
-Rob
Hi Rob,
Yes it is good practice but I thing it is not required because we are store path into variables like
Set Path = "c:\Folder\a b";
here a b is folder with spces
and we use it in store statement
Store TableName into $(Path)\TableName.qvd;
Rgds
Anand