topic Re: What is the correct syntax for 'Drop Field' in QlikView

What is the correct syntax for 'Drop Field'

Fri, 03 May 2013 10:17:14 GMT

I'm using a load * but want to modify a few fields using drop field

Load

resident TableX;

Should drop field go after the resident TableX; line or before it?

Also, when I'm adding the modified field back in, is this a separate load statement?

This is my best guess at the moment, does it look close?

Load *,

resident TableX;

Drop Field FirstName;

Drop Field LastName;

FirstName & '_' & LastName AS FullName;

Thanks guys

Re: What is the correct syntax for 'Drop Field'

er_mohit — Fri, 03 May 2013 10:20:50 GMT

ASD:

LOAD * INLINE [

A, B, C, D

1, 1, 1, 1

2, 2, 2, 2

3, 3, 3, 3

4, 4, 4, 4

5, 5, 5, 5

];

LOAD *

Resident ASD;

DROP Field A,B,C;

to using Drop field syntax

Drop Field Fieldname;

hope it helps

Re: What is the correct syntax for 'Drop Field'

Gysbert_Wassenaar — Fri, 03 May 2013 10:24:45 GMT

By dropping fields this way you remove them completely from Qlikviews in-memory database. You can also drop them from only specific tables by adding From TableX, TableY. You can't use them anymore to create new fields. So create the new field first and drop the fields when you're really finished with them. Like this:

Load *, FirstName & '_' & LastName AS FullName;

resident TableX;

Drop Field FirstName;

Drop Field LastName;

Re: What is the correct syntax for 'Drop Field'

Anonymous — Fri, 03 May 2013 10:42:24 GMT

Yes, I agree with Wassenaar, just wanted to add...you can drop all fields in single statement as well.

drop fields FirstName,LastName from TableX;

Best,

SKumar