Hi All,
How to create data model for the below scenario
Table1: this has data month wise
| cc | xlname | gcode | month | value | year |
| aa | dd | gf | jan | 33 | 2016 |
| aa | dd | gf | feb | 44 | 2016 |
| aa | dd | gf | apr | 55 | 2016 |
Table2: this contain data semester wise
| cc | xlname | gcode | semester | value1 |
| aa | dd | gf | 1 | 100 |
Master calendar:
| month | sem | year |
| jan | 1 | 2016 |
| feb | 1 | 2016 |
| mar | 1 | 2016 |
| apr | 1 | 2016 |
| may | 1 | 2016 |
| jun | 1 | 2016 |
if i select month = jan , then this should be the output
| output | | | | | | |
| cc | xlname | gcode | month | value | value1 | |
| aa | dd | gf | jan | 33 | 100 | |
| | | | | | |
