Hey , my intention is to get the derived field incremented. example - ID typ sub derived_val 100 1 100 1001 105 3 100 1003 104 2 100 1002 107 5 100 1004 108 4 100 1005 110 1 200 2001 118 3 200 2003 if the typ is 1 then the derived_val should be as cat(sub,1) and same for 2 too. But when it's 3 then the derived_val should be 1003 and then again if it's 3 then again it should be incremented by 1 and so on. The possible range for the typ is between 1 to 5. hope,it's pretty clear to you . Thanks!
... View more
