Please assist.

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

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"

;

Re: Please assist.

rubenmarin — Wed, 07 Mar 2018 14:27:19 GMT

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.