Delete a field

[#1]

Hello,

Actually I tried to manage my database and I wanted to know how can I delete an entire field.

Header 1	Header 2	Header 3
Field 1	User 1	PWD 1
Field 2	User 2	PWD 2
Field 3	user 3	PWD 3

If I delete Field 2:

Header 1	Header 2	Header 3
Field 1	User 1	PWD 1
Field 3	User 3	PWD 3

Regards

[veidlburkhard]

The difference is I loaded a html file whereas you tried to load a qvd file. So you have to tell the wizard accordingly...

[qlikviewwizard · Accepted solution]

Hi KennyHua

We can not delete any field from data model. But we can do following:

1. We can not select the field in SELECT statement

2. We can comment the field

3.We can use DROP Field FieldName from TableName statement.

Hope this will help you.

[qlikviewwizard]

Hi KennyHua

Please close the thread by selecting Correct Answer if you the answer. Thank you.