I have a requirement where we want to populate the value from one row to another in the same SPICE Dataset. I was looking in the calculated field but was not able to nail it.
current_contact_id | previous_contact_id | Questio1 | Question2 |
---|---|---|---|
xyz | abc | Hello | Guys |
abc | null | null |
current_contact_id | previous_contact_id | Questio1 | Question2 |
---|---|---|---|
xyz | abc | Hello | Guys |
abc | Hello | Guys |
How can I get this outcome