Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

about drop field

Hi

I met a problem when i use drop field clause.

the details is that:

[fact table]:
inner join ([Month table]) LOAD
     [Last Modified Date],
     Mid([Last Modified Date],4,2) as Month,
     Mid([Last Modified Date],7,4) as Year
FROM

(biff, embedded labels, table is [Sheet 1$]);

Drop field Month
from
[fact table];

the script shows as above(just a piece of the script), when i load the data, an error message came up and said cannot find field Month in drop field clause.

this confused me that though in the orignal data file it didn't exist, I created it in the script logic. Did this clause drop the field that should be exist in the data source? or I use it in a wrong method?

Many thanks!!

Br,

Lisen

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: about drop field

Hi Lisen,

According to the above script,the field Month belongs to the table [Month table],no table with name [fact table] exists as you have already joined it with [Month table].So if you want to drop the field "Month",then use this statement:

Drop field Month

from

[Month table];

3 Replies
Not applicable

Re: about drop field

Hi Lisen,

According to the above script,the field Month belongs to the table [Month table],no table with name [fact table] exists as you have already joined it with [Month table].So if you want to drop the field "Month",then use this statement:

Drop field Month

from

[Month table];

Not applicable

Re: about drop field

Hi Jemimah

thanks for your help, it works now

many thanks!

br,

Lisen

Not applicable

Re: about drop field

Yes,

Ace is true