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:

F1, Sales

A,6

B,3

Please exclude  A, Y, 2 in Test Table.

Regards

Ravi

[its_anandrjs · Accepted solution]

Write your load script like

Test:

LOAD *,F1&F2 as Key;

LOAD * INLINE

[

F1, F2, SALES

A, X, 4

A, Y, 2

A, X, 2

B, Y, 3

];

NoConcatenate

Data:

LOAD *

Resident Test  Where not Match(Key,'AY');

DROP Table Test;

Then take straight table

Dimension:- F1

Expression:- Sum(SALES)

[#3]

Thanks Anand

[its_anandrjs]

Another way of doping the same load your table like and add the 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 take a straight table

Dimension:-F1

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