Pivoting a column for 3 months

Hi guys.

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.

Thank you.

Sample Data.xlsx (9.6 KB)

Hello @denzilsdn,

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.

Br,
Ivan

4 Likes

Hi Ivan.

I will definitely give it a try.

Thank you.

Regards,
Denzil.

Hi Ivan.

Your solution is perfect.

Thank you so much.

I really appreciate it.

Regards,
Denzil.

4 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.