Is it possible to keep the order of the query fields when you get the attributes using 'Populate from SQL Query...'? I use it very often and the attributes are ordered alphabetically instead of the order in the query.
Thank you
Best answer by david_r
View original
Isn't it possible to set the order of the attributes in the 'attributes to expose' settings?
You'll have to order the attributes manually after importing them, unfortunately.
Isn't it possible to set the order of the attributes in the 'attributes to expose' settings?
https://knowledge.safe.com/idea/22950/order-of-columnsattributes-set-in-sql-is-ignored-b.html
+25
+10
If you have DDL access create a view in your DB and import that.
I have the same problem in FME 2018. A large list of attributes generated from an SQL query is sorted alphabetically in "Attributes to expose".
Is the only solution still to sort them manually?
+2
I have the same problem in FME 2018. A large list of attributes generated from an SQL query is sorted alphabetically in "Attributes to expose".
Is the only solution still to sort them manually?
Hi @stihe, Looking at the status of this related Idea, https://knowledge.safe.com/idea/22950/order-of-columnsattributes-set-in-sql-is-ignored-b.html, unfortunately I believe currently manually reordering them is still the only option. Please vote for the idea, and add your comment to give that idea more momentum. Thank you very much!
An other somewhat hacky option is to use other software, like toad, to extract the first record of your data to csv, then copy the header row and paste it into the attributes to expose.
While it takes a few steps if saves having reorder everything, especially when you have a lot of fields.
Note when you first add the transformer you can't manually edit the attributes, so just enter anything from the ... then you can paste in you list of fields on the main transformer screen.
Hope this helps
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
