Pls Help on Below Question

[#1]

Hi,

Please help on below question:

Test:

LOAD * INLINE [F1, F2, SALES

A, X, 4

A, Y, 2

A, X, 2

B, Y, 3];

OutPut Required:

F1, Sales

A,6

B,3

Please exclude  A, Y, 2 in Test Table.

Regards

Ravi

[its_anandrjs]

There is another way of doing this like load normal table and add key field

Test:

LOAD *,F1&F2 as Key;

LOAD * INLINE

[

F1, F2, SALES

A, X, 4

A, Y, 2

A, X, 2

B, Y, 3

];

And in straight table

Dimension:-F1

SET Expression:-  Sum({<Key -= {'AY'} >} SALES)

[#3]

hi,

he can take your response Massimo and he remove "noconcatenate" no ?

I tried it without "noconcatenate" and it works

regards

[its_anandrjs]

Hi Ravi,

If you got correct answer from the thread so mark the thread as Correct / Helpful.

Regards