Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Have a look here: Peek() vs Previous() – When to Use Each.
- Marcus
Please supply sample example
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
In front end, Use Above function and for script use previous function
Hi Thabiso,
Can you attach you sample .qvw file so that we can work on it.
Thanks,
V.