Hi FME folks,
Is it possible to sort the column names in the Table View in the Visual Preview alphabetically?
It's frustrating to have to scroll all the way to the right to find a column that starts with an “a”...
Thanks!
Hi FME folks,
Is it possible to sort the column names in the Table View in the Visual Preview alphabetically?
It's frustrating to have to scroll all the way to the right to find a column that starts with an “a”...
Thanks!
This can be done using the AttributeManager.
This can be done using the AttributeManager.
Can you please elaborate a bit more Niels?
I hope I don't have to drag all the Attributes manually to rearrange them alphabetically in the AttributeManager.
You can quickly change the displayed columns temporarily:
but again next time ...
Definitely ordering your fields/attributes in AttributeManager with the Up and Down buttons is the way to go. Also consider voting up my FME idea about saving table view columns for reuse Visual Preview - Preset/Saved Column Selections | Community (safe.com)
Bump.
I'm a bit fed up having to manually reorder everything in the AttributeManager.
Would a Python script work here?
If yes, can someone write it?
You can get AttributeManager to remap the Attributes in Sorted Order by re-adding them to the bottom of the AttributeManager with the Import Tool that allows Attributes to be added . The way this works is that this causes AttributeManager to remap the Schema with any overrides at the bottom of the AttributeManager operations since AttributeManager executes each line of requested operation (Rename, Remove, Do Nothing etc.) in the order they appear in AttributeManager
Do this with the “Import” Tool, and get it to re-add the Attributes to the bottom but now in Sorted order. Doesn’t matter that the same Attributes appear in the Dialog twice, because in execution AttributeManager just executes line by line, this causes it to reorder the Attributes as they are in the last line items.
Caveat is that needs to have Partial Run/Feature Cache available to map from, or an Eg. External Dataset to Import (Eg. Excel, Text/CSV etc. list of Attributes)
Anyway, going to use a Feature Cache example.
Pre-change workspace with unordered Attributes.
Use the AttributeManager “Import” Tool
Select All Attributes, and add them as new Output lines in Sorted Order
...re-adds the Attributes to the end of AttributeManager’s operations, but will reorder since they are the last operations to execute.
Changes the Workspace Scheme to now have Sorted Attributes