Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'd like to create a flag-field while loading data based on the condition:
if the value of the resident field 'Quantity'>0, flag=1, else=0.
How is it possible?
Thank you in advance,
Larisa
LOAD Quantity,
If(Quantity>0,1,0) as Flag,
....
FROM YourTable;