Can this be done with JMP?

Question

I have a really pressing need -  and I have tried everything that I know. At this point I am not even sure it can be done with JMP, but I thought I ask the Experts!

I have many records like the one below

A    B    C    D   E        
 1182401337948T     07/22/2009    DDDD       999999    1   
 1182401337948T     07/22/2009    SSSS       0    1

What I need is for every record that has D=0 and the  A and B columns are the same as to the record above - I need to create a new code DDDDSSSS and associate it with both rows

Do you think this can be done in JMP?

natalia_chalmer · Answer

Thank you Karen. I really appreciate you very quick response and great effort! Best Natalia

natalia_chalmer · Answer

Thank you Stan ! You are genius! This worked beautifully and did exactly what I was looking for.

Amazing!

stan_koprowski · Answer

Natalia,

Building on what Karen provided...

Copy and paste into your column.  I named the new column "Recoded Column".

If(Lag(:A, 1) == :A & :D  == 0, Lag(:C, 1) || :C; :Recoded Column[Row() - 1] = Lag(:C, 1) || :C, :C)

Best,

Stan