creating a flag-field while loading the data

Anonymous — Sun, 19 Jul 2015 14:53:45 GMT

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

Re: creating a flag-field while loading the data

swuehl — Sun, 19 Jul 2015 14:54:55 GMT

LOAD Quantity,

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

....

FROM YourTable;