Re: Reverse pivot challange on a nightmarish table
This one worked just as good as the previous one. Thank you guys, really appreciate the help.
Now i just need to figure out which one suits the purpouse best.
My dataset in the input table will be approx 1 mill records (1 mill unique "KEY") and as stated in the example i wil have 42 periods per KEY. So worst case it will generate 42x1mill records BUT alot of the "KEY" don have values in all 42 columns. Example if the "loan" is paid down already after 5 months there will just be 0 value in all remaining period columns.
Looking at booth of these examples, could any of you give some input on which solution would "probably" perform the best?