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.
Isn't it possible to set the order of the attributes in the 'attributes to expose' settings?
ebygomm wrote:
If you suggest it as an idea, I'd vote for it
jneujens wrote:
Isn't it possible to set the order of the attributes in the 'attributes to expose' settings?
ebygomm wrote:
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
+44- Safer
ebygomm wrote:
If you suggest it as an idea, I'd vote for it
+38- Influencer
mark2atsafe wrote:
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?
+3- Safer
stihe wrote:
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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.