Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'd been looking through Community about that but I couldn't find solution to my problem
From the logic:
if condition then
statement;
else statement;
end if
i would like to use as condition the load of at least one record from qvd file.
Any suggestions?
Thanks
Arianna
if you want only load first record you can use :
TMP:
First 1
LOAD Value
FROM ...
if you want test if else ...
suppose i have a qvd file with one field Value=1,2,3,4
i wan use if else to test the first record if its 1 or no
i can use if in load like this :
TMP:
First 1
LOAD Value
FROM
YOURQVD.qvd
(qvd);
let firstvalue=peek('Value');
if '$(firstvalue)'=1 then
let trace=1;
elseif '$(firstvalue)'<>1
let trace=0;
end if
if i show the trace variable :
more detail Help
if you want only load first record you can use :
TMP:
First 1
LOAD Value
FROM ...
if you want test if else ...
suppose i have a qvd file with one field Value=1,2,3,4
i wan use if else to test the first record if its 1 or no
i can use if in load like this :
TMP:
First 1
LOAD Value
FROM
YOURQVD.qvd
(qvd);
let firstvalue=peek('Value');
if '$(firstvalue)'=1 then
let trace=1;
elseif '$(firstvalue)'<>1
let trace=0;
end if
if i show the trace variable :
more detail Help
thanks for the kindness
Arianna