I have a scenario where I have columns Like REV_ACT_JAN ........ REV_ACT_DEC, I am doing a pivot to store all the columns in one field i.e Amount, And also i have another filed MONTH which should be identified from the Column Name(ex:REV_ACT_JAN then the MONTH field should have 01 and so on)
Could someone help me out in building this logic
Getting Month Name from Column Name
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 58
- Joined: Mon Dec 14, 2015 3:16 pm
- Location: Arizona
Getting Month Name from Column Name
anudpETL
-
- Participant
- Posts: 58
- Joined: Mon Dec 14, 2015 3:16 pm
- Location: Arizona
-
- Participant
- Posts: 8
- Joined: Mon Mar 11, 2013 2:51 pm
- Location: RTP, North Carolina
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: