Skip to main content
Question

Remove excel column


checcosisani
Contributor
Forum|alt.badge.img+12

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

4 replies

redgeographics
Celebrity
Forum|alt.badge.img+49

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).


checcosisani
Contributor
Forum|alt.badge.img+12
  • Author
  • Contributor
  • February 8, 2019
redgeographics wrote:

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


ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • February 8, 2019
Is there any sort of common naming for the attributes you want to remove? If there is the BulkAttributeRemover might be useful here

redgeographics
Celebrity
Forum|alt.badge.img+49
checcosisani wrote:

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings