how to set a new variable or field which can be used afterwards

[#1]

hi i have problems in setting a new variable or field

i have a column called runningPnL and i want a new column which is 2*runningPnL

I have tried:

but the variable is still not set:

so how can i set a variable??

please help me and thx in advance!

[mightyqlikers]

hi,

do that in the script level

like

load

          *,

              runningPnL*2 as New_runningPnL

from table;

$@M.

[ciaran_mcgowan]

Hi Kit, here are your options.

Create field in the script:

     runningPnL * 2 AS NewField

Create as a Variable in Variable Overview tool:

1. Create variable called vPnL
2. For the Definition, use runningPnL * 2
3. When calling the variable, make sure to use $(), so instead of calling vPnL, you are calling $(vPnL)

Create as a Variable in the Script:

LET vPnL = '=runningPnL * 2';

Can be referenced in the QVW without using $().