topic Re: Error Message in QlikView

Error Message

naziralala — Mon, 27 Apr 2015 15:59:17 GMT

Hello All,

I am getting the error message in Netezza as below when i try to use the applymap function.

Can someone help me resolve this issue.

Netezza Performance server

Applymap(unknown, int8)does not exist.

You need to add explicit typecasts.

Regards,

Nazira

Re: Error Message

marcus_sommer — Mon, 27 Apr 2015 18:16:44 GMT

I don't know Netezza and assume it's some kind of database which you queries from qlikview per SQL Select statement. Within such a Select statement you could only use those function which the database and the (odbc/oledb) driver provides. A qv function like applymap() will therefore fail. For this topic you need a preceeding Load, like:

table:

Load *, applymap('map', value, alternative value) as NewField;

SQL Select * From YourDatabase;

- Marcus

Re: Error Message

naziralala — Mon, 27 Apr 2015 20:31:02 GMT

Hello Marcus,

Thanks for the input.

I will try and let you know the outcome.

Nazira

Re: Error Message

naziralala — Mon, 27 Apr 2015 20:51:02 GMT

This is the correct answer..

Thank you

Re: Error Message

naziralala — Mon, 27 Apr 2015 20:53:17 GMT

Hello Marcus,

Thank You.

That was the correct answer.

Kindly explain why do we have to put in load statement?

Also, the exact difference between a load statement and a select statement?

Regards,

Nazira

On Mon, Apr 27, 2015 at 2:17 PM, Marcus Sommer <qcwebmaster@qlikview.com>

Re: Error Message

ashwanin — Mon, 27 Apr 2015 21:32:45 GMT

Hi Nazira,

Please mark the correct answer.

Re: Error Message

Anonymous — Mon, 27 Apr 2015 23:21:36 GMT

Statement SELECT is used only when you retrieve data from a database. The syntax of the select statements is defined by the database SQL. It does not understand QlikView syntax, that's why you got the error.

Statement LOAD is for any other data load. It is using QlikView syntax, including applymap().

Preceding load is a structure like this:

LOAD

A,B,C

;

SELECT

A,B,C

FROM SomeTable;

You use SQL syntax in the SELECT part, and QV syntax in the LOAD part which is loading directly from the SELECT results.

Re: Error Message

marcus_sommer — Tue, 28 Apr 2015 08:00:26 GMT

A very good explanation is here: Preceding Load.

- Marcus

Re: Error Message

naziralala — Wed, 29 Apr 2015 17:27:11 GMT

Hello Marcus,

Now by replacing lookup instead of applymap, i am not getting any error but the field names are not getting displayed.

Now, what can be the issue?

Department:

Load Dept_key, Dept_nm as "Dept Name";

Sql select Dept_key, UPPER(Dept_nm) as "Dept_nm"

from cdw.department;

UrgentCare:

Load Acct_Key, Dept_key,

lookup('[Dept Name]','Dept_key', 'Dept_key','Department')as 'Dept_3_4'

from cdw.urgentCare;

Re: Error Message

marcus_sommer — Thu, 30 Apr 2015 09:10:44 GMT

It should be rather look so:

UrgentCare:

Load Acct_Key, Dept_key, lookup('[Dept Name]','Dept_key', 'Dept_key','Department') as 'Dept_3_4';

SQL Select * from cdw.urgentCare;

- Marcus

Re: Error Message

naziralala — Thu, 30 Apr 2015 14:14:57 GMT

Hello,

This does not give an error, but does not give any data- Dept name in Dept_3_4

Thanks.

Re: Error Message

marcus_sommer — Thu, 30 Apr 2015 14:27:09 GMT

I think the syntax from lookup isn't correct, try instead:

lookup('Dept Name','Dept_key', Dept_key,'Department')

also I'm not sure if it's the proper logic, maybe rather so:

lookup('Dept_key', 'Dept Name', Dept_key,'Department')

- Marcus

Re: Error Message

naziralala — Thu, 30 Apr 2015 14:39:14 GMT

Hello Michael,

Now by replacing lookup instead of applymap, i am not getting any error but

the field names are not getting displayed.

Now, what can be the issue?

Department:

Load Dept_key, Dept_nm as "Dept Name";

Sql select Dept_key, UPPER(Dept_nm) as "Dept_nm"

from cdw.department;

UrgentCare:

Load Acct_Key, Dept_key,

lookup('[Dept Name]','Dept_key', 'Dept_key','Department')as 'Dept_3_4'

from cdw.urgentCare;

On Mon, Apr 27, 2015 at 7:22 PM, Michael Solomovich <