topic Re: Delete a field in QlikView

Delete a field

Tue, 21 Jul 2015 08:46:32 GMT

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

Re: Delete a field

sasiparupudi1 — Tue, 21 Jul 2015 08:49:23 GMT

you can use dropfiled function

drop Field YourField;

Re: Delete a field

Ralf-Narfeldt — Tue, 21 Jul 2015 08:50:20 GMT

Do you mean data you have loaded into QlikView?

If you loaded it as Table1:

Table2:

Load * resident Table1 where Header1 <> 'Field2';

Drop Table1;

Re: Delete a field

veidlburkhard — Tue, 21 Jul 2015 09:00:53 GMT

Hi Kenny,

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

Burkhard

Re: Delete a field

sasiparupudi1 — Tue, 21 Jul 2015 09:09:59 GMT

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

Re: Delete a field

Ralf-Narfeldt — Tue, 21 Jul 2015 10:51:05 GMT

That's how I interpreted it based on the data example, that it was a row to be deleted.

Re: Delete a field

Tue, 21 Jul 2015 11:57:32 GMT

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

Regards

Re: Delete a field

veidlburkhard — Tue, 21 Jul 2015 12:16:45 GMT

Hi Kenny,

no need to create aliases. Simply click on embedded lables. See below

Regards

Burkhard

Re: Delete a field

Tue, 21 Jul 2015 13:30:29 GMT

Hi,

Sorry to keep asking you, but I got something different with your picture:

DELETE:

LOAD

Header 1,

Header 2,

Hearder 3

FROM

[..\DATA\TABLES - Copie\COUNTRY.qvd]

(qvd, filters(

Remove(Row, Pos(Top,$(vNB_OF_ROW)))

));

And I got with the Wizard:

Regards

Re: Delete a field

Ralf-Narfeldt — Tue, 21 Jul 2015 13:42:55 GMT

I still think it would be easier to do it in a resident load

INPUT:

LOAD

Header 1,

Header 2,

Hearder 3

FROM

[..\DATA\TABLES - Copie\COUNTRY.qvd]

(qvd);

DELETE:

Load * resident INPUT where Header1 <> 'Field2';

Drop Table INPUT;

Re: Delete a field

veidlburkhard — Tue, 21 Jul 2015 13:45:44 GMT

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

Re: Delete a field

qlikviewwizard — Tue, 21 Jul 2015 13:46:24 GMT

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.

Re: Delete a field

qlikviewwizard — Tue, 21 Jul 2015 13:59:50 GMT

Hi KennyHua

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