Hello Expert,
I have three questions:
1. How can columns be filtered based on the column header.
For eg, Below is the format of my data:
From below table, I would like to filter months for the year 2019, which is 201901 to 201912.
Select tool can do this but is there a dynamic filter which can be made ?
| Corp Rep Group | 1701 | 1702 | 1703 | 1704 | 1705 | 1706 | 1707 | 1708 | 1709 | 1710 | 1711 | 1712 | 1801 | 1802 | 1803 | 1804 | 1805 | 1806 | 1807 | 1808 | 1809 | 1810 | 1811 | 1812 | 1901 | 1902 | 1903 | 1904 | 1905 | 1906 | 1907 | 1908 | 1909 | 1910 | 1911 | 1912 |
| A | 2.7 | 5.7 | 8.7 | 11.7 | 14.7 | 17.7 | 20.7 | 23.7 | 26.7 | 29.7 | 32.7 | 35.7 | 38.7 | 41.7 | 44.7 | 47.7 | 50.7 | 53.7 | 56.7 | 59.7 | 62.7 | 65.7 | 68.7 | 71.7 | 74.7 | 77.7 | 80.7 | 83.7 | 86.7 | 89.7 | 92.7 | 95.7 | 98.7 | 101.7 | 104.7 | 107.7 |
| B | 2.66 | 3.66 | 4.66 | 5.66 | 6.66 | 7.66 | 8.66 | 9.66 | 10.66 | 11.66 | 12.66 | 13.66 | 14.66 | 15.66 | 16.66 | 17.66 | 18.66 | 19.66 | 20.66 | 21.66 | 22.66 | 23.66 | 24.66 | 25.66 | 26.66 | 27.66 | 28.66 | 29.66 | 30.66 | 31.66 | 32.66 | 33.66 | 34.66 | 35.66 | 36.66 | 37.66 |
2. After filtering the months for the year 2019, how can substitute month numbers to month word.
example: 201901 as Jan , 201902 as Feb, 201903 as March and so on
3. All the values for the month 201901 to 201912 is imported as a string. I would like to convert all the values to double/ numeric at once. How can this be achieved without select tool.
Regards, Ravi
