storing the value of summission of a column in variable

[shivamkedia]

Table A:

ColumnName1,colmnName2

a                                   2

b                                  3

c                                  4

vVariable1=sum(columnName2) where columnName1=(a and b) i.e. vVariable1=5

i want sum (columnName2) with where condition(columnName2=a and b) and store into an variable vVariable1.

[sunny_talwar]

May be create a variable like this

Sum({<columnName1 = {'a', 'b'}>} columnName2)

[shivamkedia]

All Things must be in Script.

[shivamkedia]

 This will work in script..???

[sunny_talwar]

I am not sure I understand... are you looking to use this value in the script?

[shivamkedia]

yes.

[sunny_talwar]

Can you elaborate on how you are planning to use this in the script?

[shivamkedia]

Suppose Table B:
Column1
5
2
3;
i want to subtract the vVariable (which i get from the above condition (Reference to Table A))
from column which results in
vvariable will be = 5(sum of columnname2 of Table A)
new Table result will be:
5-vVariable
2-vVariable
3-vVariable

Final Result:
0
-3
-2

[sunny_talwar]

May be try this

Table:
LOAD * INLINE [
    ColumnName1, colmnName2
    a, 2
    b, 3
    c, 5
];

Left Join (Table)
LOAD Sum(colmnName2) as SumAB
Resident Table
Where Match(ColumnName1, 'a', 'b');

FinalTable:
LOAD *,
	 colmnName2 - SumAB as Result
Resident Table;

DROP Table Table;

[shivamkedia]

This is acceptable but doing left join with a large data(5 GB) is not logical which will increase my time thats why i was asking for the variable aproach.