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 '19 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 '19 at 6:23
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, privacy policy and cookie policy

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