Populating new fields in load script based on field values with conditions

[hucand]

I have a excel sheet that has products purchased, that looks like this:

product 1 name	product 1 amount	product 2 name	product 2 amount	product 3 name	product 3 amount
banana	10	apple	5	pineapple	2
apple	0	banana	6	pineapple	4
pineapple	5	banana	10	apple	11

I want to have a fields such as banana_amount, apple_amount, and pineapple_amount instead of having to do set expressions to see totals

How would I do that in the load script?

[G3S]

crosstable ought to work in this instance. please try.