Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
crosstable ought to work in this instance. please try.