topic Re: Problem with Where Clausule in QlikView

Problem with Where Clausule

pascos88 — Mon, 18 Jan 2016 15:55:45 GMT

I have this script and I have a problem with Where clausule.

The script cannot find Technologie field... why?

for Each Value in '[IWB]', '[EKZ]','[EWZ]', '[SPR]', '[KKB]', '[EWB]', '[EBL]', '[EBM]','[Terravent]'

Map1:

LOAD A as [Num of Wind Park],

replace(replace('$(Value)','[',''),']','') as Company,

B as CompanyName,

C as Technologie,

E as [Internal Name],

F as Portafolio,

G as [Name Project],

H as Shares,

I as Action,

J as Land,

K as Deparment,

L as DescriptionTecn,

N as [OEM Solar],

O as [Panel Type],

P as [Surface m2],

Q as [Num of Panels],

T as [Turbine Type],

S as [OEM Wind],

P as [Hub-height],

V as Power,

W as [Num of Turbine],

X as Layout,

Y as [Installed Capacity],

Z as [Instal Cap Pro_Rata],

AA as Commissioning,

AB as Acquisition,

AJ as Production,

AK as [Production per share]

FROM

[$(vSourceXLS)201601_EVU Plattform_Partner Portfolio_neE.xlsx]

(ooxml, no labels, header is 2 lines, table is $(Value)) where Technologie = 'Wind';

thanks for any help

Pasquale

Re: Problem with Where Clausule

sunny_talwar — Mon, 18 Jan 2016 15:58:26 GMT

Try this as your where statement:

(ooxml, no labels, header is 2 lines, table is $(Value))

Where C = 'Wind';

Technologies is getting created during this load. You will still need to call it using it's original field name which is C.