I need to pivot a column into the past two months and the current month.
I have Account Number, Meter Number and UOM which I can use to join on, I have the date field, and I also have a Reading Note column which I need to pivot for the past two months and the current month.
Please take a look at my extract provided to get a better understanding of what I want to achieve.
use Lag Column node (Lag should be 2 and Lag interval 1) after Group Loop Start node. Collect results with Loop End and use Table Manipulator to resort and rename your columns to get desired format. Data has to be sorted ascending based on date column (which your sample data is).
Give it a try and if any questions feel free to ask.