Load Calculated Fields

[andreamay]

Hi all, I'm new in Qlik and actually I'm working still in Qlikview.

Here my problem:

I want to load a table but with some new field that are calculated from the same fields of the table.

So here my script structure:

LOAD "A",

"B",

"C",

"D",

"E",

"F",

"A" * "B" as "G",

"C" -"D" as "H";

SQL SELECT 

"A",

"B",

"C",

"D",

"E",

"F"

FROM............;

RENAME TABLE... ;

The main proble is that Qlik say "I can't find field "G" 

Where is the main problem ?

[PrashantSangle]

your code look good to me.

Can you post screen shot of the actual script with error screen shot.

[abhijitnalekar]

Try Preceeding load as below.

LOAD*,

"A" * "B" as "G",

"C" -"D" as "H";

LOAD "A",

"B",

"C",

"D",

"E",

"F"

;

SQL SELECT 

"A",

"B",

"C",

"D",

"E",

"F"

FROM............;

RENAME TABLE... ;