Hello everyone,
I have a data set that tracks how an account moves through the sales stages.
What I am trying to do is create a row for the first stage by duplicating the existing record and moving existing data from one field to the other and null the previous field. Attached are screenshots to better explain.
Here is my data after the rows have been duplicated.
For Record ID 1 and so on I need to:
take the created date value and move it to the Edit Date field then null the created date
take the old value field and move it to the new values field and null the old value
The issues is where, [generate row] = 0 I need to keep the second 0 for each opp-id the same and make the changes to just that first row for each opp-id.
So the final result needs to look like this.
Any and all suggestions are welcome Thank you,
Nick
