Hi All,
I need a basic solution for how to add to a numeric vale in a column which is conditional as in there are thousand of rows having numeric value as (0,1,2,3,23,3,53,0,4,6,10 etc) I want to add +1 to all the data except o, that is o remains 0 but other numbers except o gets added +1 i.e 1 becomes 2, 6 becomes 7, ex- 0=0, 1=2, 5=6, 0=0 .Kindly guide me how can I achieve this.
Then I have one more requirement where if the column has value 2 it should come under a new column in range which is 0-5, in case of 40 it should be >30, in case of 7 it should be 6-15, there are three criteria's in range column which has 0-5,6-15, 16-29 and >30 . To give an overview I am attaching an image to make you understand better. Kindly help me out to solve this.
| Age | Output |
| 0 | 0 |
| 0 | 0 |
| 0 | 0 |
| 1 | 2 |
| 3 | 4 |
| 4 | 5 |
| 2 | 3 |
| 3 | 4 |
| 4 | 5 |
| Age | Range Output |
| 1 | 0-5 |
| 4 | 0-5 |
| 5 | 0-5 |
| 86 | >30 |
| 34 | >30 |
| 12 | 6-15 |
| 9 | 6-15 |
| 10 | 6-15 |
| 35 | >30 |
