6 Replies Latest reply: Jun 4, 2015 1:27 AM by balkumar chandel

# Help

Input

A, 12

B, 13

C, 14

D, 15

Output

AB  25

CD 29

• ###### Re: Help

You want a front end solution?

Create a straight table chart, with a calculated dimension

=if( Match(DimField,'A','B'), 'AB','CD')

and as expression

=sum(NumberField)

• ###### Re: Help

source:

load *, div(rowno()+1,2) as field3 inline [

f1,f2

A, 12

B, 13

C, 14

D, 15

E,10

F,20

];

final: NoConcatenate load concat(f1) as f1, sum(f2) as f2 resident source group by field3;

DROP Table source;

• ###### Re: Help

what's the rationale of the letter groups?

• ###### Re: Help

Hi Lalit,

Have a look into the qvw file.

Hope it helps.

Regards,

Jemimah

• ###### Re: Help

Hi Lalit,

On what basis and AB and CD should be grouped?  what if E, F, G, H available?  Is there any logic to group?

Regards,

jagan.

• ###### Re: Help

Can you tell the grouping logic,

for your example you can use straight table with calculated dimension =pick(match(Col1,'A','B','C','D'),'AB','AB','CD','CD')

then in expression sum (Col2)

Thanks

BKC