6 Replies Latest reply: Jun 4, 2015 4:18 AM by Marco Wedel

# Help

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

f1    f2

AB,  3

BC,  5

CD,  7

DE,  9

EF,  11

FG,  13

GH,  15

• ###### Re: Help

Hello!

t1:

f1,     f2

A,    1

B,    2

C,   3

D,   4

E,   5

F,   6

G,   7

H,   8

];

left Join (t1)

Resident t1;

Left Join (t1)

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

Resident t1;

t2:

f1&f1new as f1,

f2+f2new as f2

Resident t1

Where not IsNull(f2new);

DROP Table t1;

• ###### Re: Help

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 you are viewing this topic and found it informative, please like my comment.

Regards

Dhruv

• ###### Re: Help

Hi

Try like this

LOAD * where f2 <> Null();

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

[

f1,f2

A,    1

B,    2

C,   3

D,   4

E,   5

F,   6

G,   7

H,   8

];

• ###### Re: Help

hi,

See the attached sample..

• ###### Re: Help

Logic Help