LOAD script - Duplicate row with condition and change 1 field in that row

[freddean]

Hi all,

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

[StarinieriG · Accepted solution]

Hi,

you could try with something like this

TABLE:

LOAD * From Table;

Concatenate (TABLE)

LOAD 

...

(all fields)

...

... as Bucket#

Resident TABLE

Where [portion to prev bucket]>0 or [portion to curr bucket]>0

;

If you don't have [portion to prev bucket] and [portion to curr bucket], you need to group by before the where

[Brett_Bleess]

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.

Regards,
Brett