Discussion Board for collaboration on QlikView Scripting.
Actually I tried to manage my database and I wanted to know how can I delete an entire field.
If I delete Field 2:
Go to Solution.
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.
you can use dropfiled function
drop Field YourField;
Do you mean data you have loaded into QlikView?
If you loaded it as Table1:
Load * resident Table1 where Header1 <> 'Field2';
seems you want to delete one row and not a field. If so you can use the file wizard and easily delete the marked row or chose a conditon to conditionally delete it:
Hope this helps
If you want to delete a row in an already loaded table, you could only use another resident load excluding the problem row.
I suggest you go wiith the solution given by rnt
That's how I interpreted it based on the data example, that it was a row to be deleted.
It's very interesting, but do you know if it's possible de keep the column name ? Because actually when I take your way, Each column is replaced by @1, @,2 and I want to keep Header 1, Header 2, ...
I don't want to creat alias because I have a lot of table to manage
no need to create aliases. Simply click on embedded lables. See below
Sorry to keep asking you, but I got something different with your picture:
[..\DATA\TABLES - Copie\COUNTRY.qvd]
And I got with the Wizard:
I still think it would be easier to do it in a resident load
Load * resident INPUT where Header1 <> 'Field2';
Drop Table INPUT;