pivot table join...???

[#1]

Sorry. i do not speak english..

tab1:
LOAD * INLINE [
a, b
11, 1
22, 2
33, 3
];

tab2:
LOAD * INLINE [
c, d
11, 99
22, 88
];

I want not join. I want to handle the pivot table.

So...

I written....

sum({<a={"$(=GetFieldSelections(c))"}>}d)

current result:

a	Sum (b)	sum(d)
11	1	187
22	2	187
33	3	187

i want results:

a	Sum (b)	sum(d)
11	1	99
22	2	88
33	3	0

plz......

[Anonymous]

Here's an easy way to write the expression:

sum(if(a=c,d))

[#3]

Thank you very much.

but...

'if' is performance problem.(over 10000000 data)

ex>

SUM({<STD_DT={'20100501'}>} IF((a = b) AND (c = d) AND (e = f) AND (g = h) AND (i = j),kk)

It is take a long time....(10 minute.) ^^;;;;