Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

rams_school
New Contributor III

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

Re: how to delete the field name?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
qlikviewnovice
Valued Contributor II

Re: how to delete the field name?

We have to delete manually

Highlighted
psilva001
Contributor

Re: how to delete the field name?

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

DROP FIELD [field] FROM

;