Skip to main content
Solved

Arrange in an ascending manner

  • May 27, 2020
  • 2 replies
  • 21 views

mr_fme
Enthusiast
Forum|alt.badge.img+9

Hi,

 

In my workflow, I am creating an .xls file with some sheets, there are two columns. One of them with the value is with the word sector and corresponding number. Eg: Sector 1, Sector 3 ...

 

How do I enter these values in ascending order.

 

Currently it looks like this:

 

Sector 4

Sector 4

Sector 6

Sector 6

Sector 3

Sector 3

Sector 1

Sector 1

 

Sorting is being done alphabetically, by another column.

 

Thank´s

Best answer by erik_jan

Have a look at the Sorter transformer (to be placed right before writing the data).

Hope that helps.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • Best Answer
  • May 27, 2020

Have a look at the Sorter transformer (to be placed right before writing the data).

Hope that helps.


mr_fme
Enthusiast
Forum|alt.badge.img+9
  • Author
  • Enthusiast
  • May 27, 2020

Have a look at the Sorter transformer (to be placed right before writing the data).

Hope that helps.

Thank´s