topic Re: Qlikview 11 for Developers - Error in loading book script in QlikView

Qlikview 11 for Developers - Error in loading book script

Tue, 25 Mar 2014 22:31:58 GMT

Refer - Page 290, Point 11 - "

In the Link Table tab, add the following script: [Link Table]:................[Carrier Name] From [Main Data];"

These error occur when I load the script -

--->

Field not found - <Period>

[Link Table]:

Load Distinct

[%Key Field],

[%Key Field] as [%TEMP Key Field],

Year,

Period,

[Month (#)],

Month,

Quarter,

[%Airline ID],

[%Unique Carrier Code],

[%Carrier Group ID],

[Unique Carrier],

[Carrier Code],

[Carrier Name]

Resident [Main Data]

--->

Table not found

Concatenate ([Link Table])

Load Distinct

[%Key Field],

Year,

Period,

[Month (#)],

Month,

'Q' & Ceil([Month (#)]/3, 1) as Quarter,

[%Airline ID],

[%Unique Carrier Code],

[%Carrier Group ID],

[Unique Carrier],

[Carrier Code],

[Carrier Name]

Resident [Employment Statistics]

Where Not Exists([%TEMP Key Field], [%Key Field])

--->

Field not found

Did not find the field "%TEMP Key Field" from the DROP FIELD statement

--->

Field not found

Did not find the field "Period" from the DROP FIELD statement

--->

Field not found

Did not find the field "Period" from the DROP FIELD statement

Re: Qlikview 11 for Developers - Error in loading book script

Tue, 25 Mar 2014 22:33:42 GMT

Please check in your MainData table whether there is a field called 'Period'. That is the main error. Once you fix that, other errors will disappear.

Re: Qlikview 11 for Developers - Error in loading book script

Tue, 25 Mar 2014 22:42:04 GMT

Actually, there is a aliased field Period in MainDataTable as shown below. It looks like the book might have an error -

Period

& ' | ' & [%Airline ID]

& ' | ' & [%Unique Carrier Code]

& ' | ' & [%Carrier Group ID] as [%Key Field],

Re: Qlikview 11 for Developers - Error in loading book script

Tue, 25 Mar 2014 22:46:46 GMT

can you post the statement for MainData, You are missing a comma after the work 'Period'. Please double check.

Re: Qlikview 11 for Developers - Error in loading book script

Tue, 25 Mar 2014 22:47:39 GMT

My mistake. The book told me to -

Create a new compound key on both of the tables by using the following

script expression:

Period

& ' | ' & [%Airline ID]

& ' | ' & [%Unique Carrier Code]

& ' | ' & [%Carrier Group ID] as [%Key Field],

I replaced Period by the above code.

Thanks.