Hy
I need to read several excel files and remove a lot of columns (fields) so the usage of attribute manager isn't efficient
How can do this in smart way ?
thx
Francesco
Question
Remove excel column
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.
+62- Celebrity
If you need to remove lots of columns try the AttributeKeeper, there you can select which ones you want to keep (if you want to keep more than you want to remove, there's the AttributeRemover which works the other way around).
+14- Contributor
If you need to remove lots of columns try the AttributeKeeper, there you can select which ones you want to keep (if you want to keep more than you want to remove, there's the AttributeRemover which works the other way around).
Hi
yes I realize that attrkeeper can helps me but any idea how can automatize the selection in attribute keeper (I have 1850 columns and I have to keep 30)?
thx
Francesco
+46- Influencer
Is there any sort of common naming for the attributes you want to remove? If there is the BulkAttributeRemover might be useful here
+62- Celebrity
Hi
yes I realize that attrkeeper can helps me but any idea how can automatize the selection in attribute keeper (I have 1850 columns and I have to keep 30)?
thx
Francesco
Perhaps the SchemaMapper can be used, I haven't worked with it myself in a long time, but there's a tutorial here.
Alternatively, Python might come in handy, but again, no experience with that myself.