5

I have a simple model that just does a series of queries/data cleanups and then puts the data into a csv. Unfortunately it's being put into the CSV in a random order.

How can I get it to write in order?

enter image description here

Running this I get

enter image description here

But I need it to be Lot Plan, then Prop No, Land No, Street address and finally toilets.

Based on https://knowledge.safe.com/questions/40473/is-it-possible-to-make-a-transformer-wait-for-the.html I added a connection run time order but still get the same output.

enter image description here

I am using the current ver of FME desktop.

UPDATE:

Here's what worked. enter image description here

2
  • 1
    have you tried the sorter transformer before the writer? if needed you can create a temporary attribute to sort on.
    – JimT
    Jul 2, 2019 at 6:16
  • 1
    I hadn't but have done it now and it works. So I just add tOrder and put in value 1-5 and then sorted by that and it worked. If you want to add as an answer I can accept it.
    – GeorgeC
    Jul 2, 2019 at 6:23

1 Answer 1

6

Use the Sorter transformer before the writer. It will output features in sorted order against the selected attribute(s).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.