Help

[#1]

Hi,

    Tell Me Solution.My Input Table is Below

f1     f2

A,    1

B,    2

C,   3

D,   4

E,   5

F,   6

G,   7

H,   8

I Want To This OutPut.It Should Be Dynamically code. Please Help Me.

f1    f2

AB,  3

BC,  5

CD,  7

DE,  9

EF,  11

FG,  13

GH,  15

[pokassov]

Hello!

t1:

LOAD * Inline [

f1,     f2

A,    1

B,    2

C,   3

D,   4

E,   5

F,   6

G,   7

H,   8

];

left Join (t1)

LOAD *, RecNo() as ID

Resident t1;

Left Join (t1)

LOAD ID-1 as ID, f1 as f1new, f2 as f2new

Resident t1;

t2:

LOAD

  f1&f1new as f1,

  f2+f2new as f2

Resident t1

Where not IsNull(f2new);

DROP Table t1;

[MayilVahanan]

Hi

Try like this

LOAD * where f2 <> Null();

LOAD Previous(f1)&f1 as f1, f2+Previous(f2) as f2;

LOAD * Inline

[

f1,f2

A,    1

B,    2

C,   3

D,   4

E,   5

F,   6

G,   7

H,   8

];

[#4]

hi,

See the attached sample..

[#5]

Refer the link below.

Logic Help

[djsampat]

Hi Lalit,

Using the above logic by @Сергей Покасов, I have created a qvw so you can see it at work if you did not understand the coding.

view attached.

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

If you are viewing this topic and found it informative, please like my comment.

Regards

Dhruv

[MarcoWedel]

Please also answer the questions in your thread

Help

Thanks

Regards

Marco