Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Here is my question, how to set conditional statement in loading script?
I would like to load new data when [Field1] = 0, reload/remain existing data when [Field1] =1.
I am using the following scripts:
Load [Field1],
...
From ...
Exit script when [Field1] = 1
But there is problem, when exit script, no data will be loaded, so all charts and tables are empty, no data to display.
Please help, thank you.
Regards,
Lee
My another tryout:
but no working very well.
------------------------------------------------------------------------
If [Field1] = 0 then
data:
load ....
from ....
store data into \QVD\data.qvd(qvd);
else
data:
load ....
from \QVD\data.qvd(qvd);
end if
drop table data;
Hi,
Try like this:
Create a vField1 Variable and assign.
IF vField1 = '0' THEN
Data:
Load *
From QVD;
Endif;