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
Solved
SQLExecutor - Keep order when populating the attribute list for the query
Best answer by david_r
You'll have to order the attributes manually after importing them, unfortunately.
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.
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.
Isn't it possible to set the order of the attributes in the 'attributes to expose' settings?
- 8394 replies
- Best Answer
You'll have to order the attributes manually after importing them, unfortunately.
- 8394 replies
If you suggest it as an idea, I'd vote for it
Isn't it possible to set the order of the attributes in the 'attributes to expose' settings?
If you suggest it as an idea, I'd vote for it
https://knowledge.safe.com/idea/22950/order-of-columnsattributes-set-in-sql-is-ignored-b.html
+56- Safer
- 2554 replies
If you suggest it as an idea, I'd vote for it
+44- Influencer
- 3429 replies
fwiw (they may not count it) I voted for this!
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?
+11- Safer
- 324 replies
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