Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Oh my,,,how simple.
Thx!
it seems you already have the answer
LOAD
If(Data>0, 'Belastung', 'Entlastung') as Indicator,
Konto,
Data
From xyz;
I had tunnel vision....
Philip please use Massimo solution..