Logic Help

[abhaysingh]

Hi all,

i have one requirement can any one help me in this?

Header 1	Header 2	Header 3
A	1
B	2
C	3
D	4
E	5
F	6

Output should come in table like

Header 1	Header 2
ABC	6
DEF	15

A+B+C = 6

D+E+F=15

how i can do this?

thanks in advance

[abhaysingh]

Giving me static value of ABC and for DEF and value of GHI added into DEF only..

i have added GHI value as appended Data..

Looking for Dynamic Solution For this

[#3 · Accepted solution]

Hi Abhay,

Have a look at the attached qvw.

Hope this helps.

Regards,

Jemimah

[CELAMBARASAN]

May be it could help

Test:

LOAD Ceil(RowNo()/3) AS Group,* INLINE [

    Header 1, Header 2

    A, 1,

    B, 2,

    C, 3,

    D, 4,

    E, 5,

    F, 6

];

Tab:

LOAD Group, Concat([Header 1]) AS Header, Sum([Header 2]) AS Total

Resident Test

Group By Group;

Drop Table Test;

[#5]

Try this. It could help.

test:

load * inline

[

H1, H2

a, 1

b, 2

C, 3

d, 4

e, 5

f, 6

g, 7

h, 8

i, 9

];

Left Join(test)

LOAD H1, FieldValue('H1', RecNo() - Mod(RecNo() - 1, 3)) & FieldValue('H1', RecNo()+1 - Mod(RecNo() - 1, 3)) &FieldValue('H1', RecNo()+2 -Mod(RecNo() - 1, 3)) as NewH1

Resident

test;

LOAD NewH1, Sum(H2) as NewH2

Resident test

Group by NewH1;

Refer attached file.