Hi All,
i am having an issue with one of my table and I wanted to create a new columns with Date (this is dynamic) using below table.
Record ID | Monthly | Quarterly | Yearly |
1 | OCT 21 | 4Q 21 | FY21 |
2 | 12344 | 32123 | 123123 |
3 | 12312 | 23243 | 745646 |
4 | 54533 | 23423 | 644234 |
5 | 12345 | 43455 | 54543 |
I am looking for below table by using the above one.
Record ID | Monthly | Quarterly | Yearly | Month | Quarter | Year |
1 | OCT 21 | 4Q 21 | FY 21 | OCT 21 | 4Q-21 | FY21 |
2 | 12344 | 32123 | 123123 | OCT 21 | 4Q 21 | FY21 |
3 | 12312 | 23243 | 745646 | OCT 21 | 4Q 21 | FY21 |
4 | 54533 | 23423 | 644234 | OCT 21 | 4Q 21 | FY21 |
5 | 12345 | 43455 | 54543 | OCT 21 | 4Q 21 | FY21 |
Regards,
Shiva
Solved! Go to Solution.
This was a super fast response 🙂
Thank you
Happy to help : ) @shivanand612
Cheers and have a nice day!