Showing Number a decimal point sequence

[Markbhai]

Hi there.

I have a series of documents which are version numbered, e.g. 5.1, 5.2, ...5.9, 5.10, 5.11 etc.

Any number which ends in a zero is converted to remove the zero (e.g 5.10 becomes 5.1)

I would like two things:

1 - Show numbers as thier original form, e.g. 5.10 should be 5.10

2 - Allow sorting on the field ascending e.g (5.1, 5.2, 5.3, 5.4, 5.5, 5.6, 5.7, 5.8, 5.9, 5.10, 5.11 etc)

Thanks for your help.

Mark.

[MayilVahanan]

Hi

Try like below

Load Dual(Text(Num), Num#(Replace(Num, '.',''))) as Num Inline
[
Num
5.1
5.2
5.3
5.10
5.11
];

[Markbhai]

Thanks for your help, so my field is called Control Number I should use:

Load Dual(Text([Control Number]), Num#(Replace([Control Number], '.',''))) as [Control Number] Inline

Thanks

[MayilVahanan · Accepted solution]

Hi

Yes, if it is inline load, suppose if its from load statment

Load  Dual(Text([Control Number]), Num#(Replace([Control Number], '.',''))) as [Control Number] 

from yourdatasource;

[Markbhai]

Thanks

That worked great.

M