Calculating Quarter for Month

 Calculating Quarter for Month


1. Assuming your month values are going to be in same format in source file


2. Job Design 



3. Take lookup of Month and Quarter as shown below


4. Take Inner join on Month column 




5. Final output will look like this




1 comment: