creating a flag-field while loading the data

[Anonymous]

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

[swuehl · Accepted solution]

LOAD Quantity,

          If(Quantity>0,1,0) as Flag,

          ....

FROM YourTable;