In my base, I have 2-tables. The first table contains all of my primary data—the second table with additional data related to my first table.
In table-1, I have a column named “month number”, which means a number will represent a month; i.e. 2 = February or 12 = December etc.
It looks like this:
Month Number
1
5
8
9
In table 2, I have a column named “Month”, with all the months of the year in their own lines.
Example:
JAN
FEB
MAR
Next to that column, I have a column named “Month Number.” Which obviously resulted in having numbers 1 to 12, next to the months of the year.
In my first table, next to the column named “Month Number” I’ve added a column called “Month_Name”. In this column, I want the column to identify that a number represents a specific month name and fill in the column with the corresponding name.
For example:
If 4 = APR, then I want APR to appear in the “Month_Name” column next to it’s “Month Number” column.
So it will look like this:
Month Number
4
Month_Name
April
Your help will be highly appreciated.
Thanks
