If condition

gab_cerelli — Thu, 29 Apr 2021 10:09:28 GMT

Hi everyone,

I've a problem with a condition that I need to insert in a table already created.

I'll explain in practical terms, I've two values aggr (sum) in the table (we'll call them value X and Y) and I need to create a Z value like this:

If X<(0.5Y) then Z=Y+0.2Y ;

Can someone help me please?

Thank you

Re: If condition

jwjackso — Thu, 29 Apr 2021 19:50:40 GMT

If you can modify the load script, you can use a Preceding Load statement

Data:

load *,

If (x<.5Y,Y+0.2Y) as Z;

load Sum(X),

Sum(Y)

From SomeTable;