Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
];
hi,
See the attached sample..
Refer the link below.
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