Please assist.

[suvechha_b]

Hi All ,

How can I compare value of one row field with the other row of same field .

For eg,

if previousdealid value match the 1 elso 0.

My requirement

For eg,

my result should have id -

328

1653

3373

3385

16799

172629

17361

21799

I tried to use peek() and previous() in script but not working. Please assist .

"OpenUser_final3":

NoConcatenate

LOAD

*,

if(previousdealid=Previous(previousdealid),Null(),Previous(previousdealid)) as flag

Resident "OpenUser_final2"

;

[rubenmarin]

Hi Suvechha, using previous is almost required to use an 'order by' clause to sort the records, in this case it can be:

Order by previousdealid, DateJoinedKeyPL;

Or you can join both tables by dealerid to have both fields in the same row in date model.