Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
rams_school
Contributor III
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
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..

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
Specialist II
Specialist II

We have to delete manually

psilva001
Creator
Creator

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

DROP FIELD [field] FROM

;