LOAD script - Duplicate row with condition and change 1 field in that row
What I would like to do is: 1. select a row from a populated table where both the fields (portion to prev bucket & portion to curr bucket) have a value > 0 2. put the rows that satisfy that condition into a separate table. 4. in that table I want to change a value to be value - 1 in a specific field (bucket#). 6. I want to concatenate the table with the new rows with the altered bucket# back into the original table.
Below is what my pivot table currently looks like:
And this is what I want it to look like:
Difference is: in result transaction VF32 exists in bucket 1 and bucket 2. Transaction A445 exists in both bucket 2 and bucket 3
Fred, did Giulia's post help you with things? If it did, be sure to use the Accept as Solution button on the post to mark it as correct, and give credit. If you did something else, consider posting that and then marking it, and if you are still working on things, leave an update on where you are.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.