New column by script

[luca_bellotti]

Hello to everyone,

I've tried to solve this problem but I can't figure it out. Maybe someone  could help me.

I've loaded the TABLE1 by script editor

TABLE1

NAME	A	B	C	D
RED	100	98	10	50

What I need to obtain is a new table with another column  (E) with the following formula C+((A-B)/D)

TABLE2

NAME	A	B	C	D	E
RED	100	98	10	50	10,04

Thank everyone who might help me.

[YoussefBelloum · Accepted solution]

Hi,

try this:

Table1:

load

.

.

FROM

TABLE2:

LOAD

C+((A-B)/D) as E

resident Table1;

[luca_bellotti]

It worked. Thank you Youssef.

[YoussefBelloum]

You're welcome