Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to load a QVD with all the needed fields from multiple tables in my script. Is it possible and how to do that. Please let me know. Thanks - Sasi
Hi Sasi,
After you making Qvd and call all the required Qvd's to ur Application as per ur requirements later if u missed 1 or 2 coloumns u can go to edit script and add the column and reload the application .
Then u can see ur added coloumns also there.
hope this help
regards,
Mohanraj Subramanian
hiii
a:
load table from xls.
then
store a into c/user/desktop.qvd;
means
store tablenae into pathname.qvd;
then reload after that del. the tables
and load table file from qvd where you give the path.then
when you loadind the tables from qvd in qlikview using table file then it shows the option next and again it gives enable transformation step to click on that escape it and go further next then you can got table fields with cross sign and those fields which are not required you can del. that
see the image attach
hi
LOAD customer,
salary
FROM
(ooxml, embedded labels, table is Sheet1);
STORE Sheet1 into
then ctrl E
clik on tables files
then add qvd file.
then you get all fields of qvd file