How to Get Previous Row Answer

[#1]

Hi,

Im trying to get an answer for Previous Row Answer as below:

Numbers	Names
1234	A
1234	B
12354	C
12354	D
12543	E
1234	F
54321	G

The Previous im using its looking at the Previous Corresponding Same Number, so i need previous row

as like Current row is determined by the previous Row.

[marcus_sommer]

Have a look here: Peek() vs Previous() – When to Use Each.

- Marcus

[#3]

Please supply sample example

[marcus_sommer]

It's something like this:

t1:

Load * From Source;

t2:

Load *, if(Numbers = peek('Numbers', -1), Then, Else) as NewField Resident t1 order by Numbers;

drop tables t1;

Important is to order the load within a resident load and then check the rows against each other. maybe you need to implement a few more check-logics (if's).

- Marcus

[timanshu]

In front end, Use Above function and for script use previous function

[vishsaggi]

Hi Thabiso,

Can you attach you sample .qvw file so that we can work on it.

Thanks,

V.