sorting with a multiple-digits integer filed

OL Connect Professional General
1

I am sorting the data with a multiple-digits integer data field. Here is a piece of the data:

289099,

380169,

2595993,

9066352,

10043133

This is supposed the correct order after sorting in Connect Designer. However, I got a different result as:

10043133,

289099,

380169,

2595993,

9066352

How can I get around with this issue?

Appreciate any suggestion and idea.

2

It looks like your fields are Strings. If you extracted them as numbers, then the sorting order would be correct.

3

Actually I tried both types, string and integer. Both ways were not working. I may try to use string type and pad zeros whenever where needs to make them the same length. Thanks for your kind response.

4

How exactly are you sorting those values in the Designer?

5

I was creating a job present, grouping the data with mailing_address_id. Those values in my previous posting were mailing_address_ids. They have the integer type in SQL database.