Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How do I insert multiple values from a single input box. When I insert a value in the input box and append it to the original table and Later when I try to insert a different value in the input box, it overwrites the old value.
Thanks.
Hi Sir,
I tried the steps you mentioned, but the values are still being overwritten. This is my code. Please review and suggest if there are any errors.
LET vListQVDExists = not isnull(QVDCreateTime('Test.qvd'));
SalesDesc:
LOAD * Inline [
Customer, Sales Order ID,ShipDate,Product,Sales,Quantity
$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)
];
IF $(vListQVDExists) then
Concatenate(SalesDesc)
LOAD * From Test.qvd (qvd);
ENDIF
STORE SalesDesc into 'D:\Projects\Test.qvd';
Is there any way to store two values of a single field using one input box.
Thanks.
Can you share this sample QVW and the excel file you are trying to load
Hi,
Here are the qv file and the excel data.
Thanks.
Bhagirath, Thank You Sir, for the effort you took into explaining me the solution.
I got the answer finally. The code is as you said. I just had to do a Partial Reload everytime I want to add a value.
----------------------------------------------------------------------------------------
LET vListQVDExists = not isnull(QVDCreateTime('Test.qvd'));
SalesDesc:
LOAD * Inline [
Customer, Sales Order ID,ShipDate,Product,Sales,Quantity
$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)
];
IF $(vListQVDExists) then
Concatenate(SalesDesc)
LOAD * From Test.qvd (qvd);
ENDIF
SalesNewDesc:
ADD LOAD * Inline [
Customer, Sales Order ID,ShipDate,Product,Sales,Quantity
$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)
];
STORE SalesDesc into 'D:\Projects\Test.qvd';
------------------------------------------------------------------------------------
Adding the ADD keyword before the LOAD fucntion allows to partial reload..
Thanks.
Hi Siddhesh,
Can you please recheck, make sure every time you enter values to input box u need to save your document and then reload
i have done some dummy entries, see the attached QVD and paste it in the same location where qvw is.
I dont think you can this input solution for Acesspoint, because the reload at server will not save values of variables user has changed.
anyways you can mark my solutions correct or useful if it has helped you
Yes. Every time I reload, the values are entered into the table and then saved into the qvd file. But as you said this won't be the case while doing a reload at server.
Thanks.
I am also attaching you the file. You can check and suggest me if I have made a mistake.
you do not need this statement
SalesNewDesc:
ADD LOAD * Inline [
Customer, Sales Order ID,ShipDate,Product,Sales,Quantity
$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)
];
as you have already loaded the same in SalesDesc
below script is fine
LET vListQVDExists = not isnull(QVDCreateTime('Test.qvd'));
SalesDesc:
LOAD * Inline [
Customer, Sales Order ID,ShipDate,Product,Sales,Quantity
$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)
];
IF $(vListQVDExists) then
Concatenate(SalesDesc)
LOAD * From Test.qvd (qvd);
ENDIF
STORE SalesDesc into 'D:\Projects\Test.qvd';
you can load the excel file data immediately after this and get that concatenated with the SalesDesc table