Calculate Indicator in Script

[Anonymous]

Hi,

i need to calculate a column in script for existing table:

I have a table like:

LOAD

Konto,

Data

From xyz;

And the calculated field should look like:

If(Data>0, Belastung, Entlastung) as Indicator

How can in achieve this?

[robert_mika · Accepted solution]

t1:

LOAD Konto,

     Data

FROM

[..\Desktop\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

t2:

load

Konto,

If(Data>0, 'Belastung', 'Entlastung') as Indicator

resident t1;

drop table t1

[Anonymous]

Oh my,,,how simple.

Thx!

[maxgro]

it seems you already have the answer

LOAD

  If(Data>0, 'Belastung', 'Entlastung') as Indicator,

  Konto,

  Data

From xyz;

[robert_mika]

I had tunnel vision....

Philip please use Massimo solution..