Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a QVD file to which I need to add a FLAG (Yes/No).
The rule for the flag is if(Balance) >= 0 or Null than Flag = No and if(Balance) <0 than Flag = Yes.
Thanks,
H
Assuming that "Balance" is a fieldname in the QVD and "Flag" as the fieldname to be added, try the following code:
LOAD *, If(IsNull(Balance) or Balance >= 0,'No','Yes') as Flag;
LOAD * from Your.qvd (qvd);
Assuming that "Balance" is a fieldname in the QVD and "Flag" as the fieldname to be added, try the following code:
LOAD *, If(IsNull(Balance) or Balance >= 0,'No','Yes') as Flag;
LOAD * from Your.qvd (qvd);