topic Re: about drop field in QlikView

about drop field

Wed, 21 Jan 2015 03:19:37 GMT

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

Re: about drop field

Wed, 21 Jan 2015 04:04:06 GMT

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];

Re: about drop field

Wed, 21 Jan 2015 05:03:08 GMT

Hi Jemimah

thanks for your help, it works now

many thanks!

br,

Lisen

Re: about drop field

Wed, 21 Jan 2015 06:55:38 GMT

Yes,

Jemimah Bag is true