Load data if

[Arianna1]

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

[Taoufiq_Zarra · Accepted solution]

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

[Arianna1]

thanks for the kindness

Arianna