Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to delete the field name?

I have Individual Excel sheet for monthly data. The field name different is some excel sheet. so When I re-use my QV files and reload other excel file the field name shows error so I manually correct.

When I see the Table properties I get lots of unwanted field name. I want to get rid (Delete) of this unwanted field name.

How do I do it?

Please refer to the attached image

TableUnwantedField.JPG

3 Replies
Anil_Babu_Samineni

There is not best way but you can remove manually using multi selection wither Ctrl + Shift key and then Click ok then reopen the properties there you can't see those from sections..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

We have to delete manually

Anonymous
Not applicable
Author

You can edit your script writing this expression at the final of the instructions.

DROP FIELD [field] FROM

;