Adding a new field with addition of 1.

[MuraliPrasath]

Hi QV,

I have field [ITEM] with value of 1,2,3,5,7

I need a new field with respect to [ITEM] field +1.

Ex:

ITEM, NewITEM

1,      2

2,      3

3,      4

5,      6

7,      8

[sunny_talwar · Accepted solution]

May be this:

LOAD ITEM,

          ITEM + 1 as NewITEM

FROM Source

[MuraliPrasath]

thanks Sunny.