invert a sequence column in a dataset

chrisgo — Wed, 25 Feb 2015 01:56:55 GMT

I would want to invert a sequence/order column in a dataset given a max sequence order:

example:

max sequence order=4

col1 seq

A 1

B 2

C 3

D 4

E 2

F 1

change to:

col1 seq

A 4

B 3

C 2

D 1

E 3

F 4

Thanks,

Re: invert a sequence column in a dataset

Howles — Wed, 25 Feb 2015 02:22:30 GMT

how about

seq = 5 - seq ;

chrisgo — Wed, 25 Feb 2015 02:37:47 GMT

thanks